Formatting numeric values in a GridViewDataColumn with a custom group separator

[Pascal GUERY]

Hi everyone,

I have developed a sample WPF projet referencing RadControls for WPF Q3 2013 Trial Version assemblies.
The main window contains a RadGridView.
The RadGridView has only one column which is a GridViewDataColumn.
I have written code in the main window's constructor to fill the RadGridView's Items collection with anonymous objects.
The anonymous objects have only one property named Value and whose type is double.
The GridViewDataColumn is bound to the Value property.

Here is the main window's XAML markup :

<Window x:Class="GridViewColumnFormat.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <telerik:RadGridView x:Name="m_grid" AutoGenerateColumns="False">
            <telerik:RadGridView.Columns>
                <telerik:GridViewDataColumn DataFormatString="F2" DataMemberBinding="{Binding Path=Value}" />
            </telerik:RadGridView.Columns>
        </telerik:RadGridView>
    </Grid>
</Window>

Here is the main window's code-behind :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace GridViewColumnFormat
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();

            for (double l_index = 1000; l_index <= 20000; l_index += 1000.99)
            {
                m_grid.Items.Add(new { Value = l_index });
            }
        }
    }
}

The attached picture shows the main window.

I have set the GridViewDataColumn's DataFormatString property.
I want the space character to be the group separator for displaying values.
How can I set a custom group separator ?

Thank your in advance for your help

[Pascal GUERY]

I have submitted a support ticket describing the same need by using a Telerik account with a valid support license.
The support ticket's ID is 794929.
You are not forced to reply to this thread.
I wanted to delete this thread but I do not know how to do it.

[Hristo]

Hello Pascal,

You can achieve the desired behavior by modifying the current culture. In order to apply this culture to the RadGridView you will have to set the property IsLocalizationLanguageRespected to false. More information on this property can be found here.

Please check the attached project for more details.

Regards,
Hristo
Telerik

[Hristo]

Hello Pascal,

You can achieve the desired behavior by modifying the current culture. In order to apply this culture to the RadGridView you will have to set the property IsLocalizationLanguageRespected to false. More information on this property can be found here.

Please check the attached project for more details.

Regards,
Hristo
Telerik

 

 

[Hristo]

Hello Pascal,

You can achieve the desired behavior by modifying the current culture. In order to apply this culture to the RadGridView you will have to set the property IsLocalizationLanguageRespected to false. More information on this property can be found here.

Please check the attached project for more details.
 
Regards,
Hristo
Telerik

 

 

[Administrator]

Hello Pascal,

You can achieve the desired behavior by modifying the current culture. In order to apply this culture to theRadGridView you will have to set the property IsLocalizationLanguageRespected to false. More information on this property can be found here. 

Please check the attached project for more details.

Regards,
Administrator
Telerik