Using the ExportTelerikGridDataUserControl with non-US culture

[HotlineOrbicon]

I have a WPF RadGridView with an associated ExportTelerikGridDataUserControl.
Using da-DK culture the XML export shows up in Excell with no decimals on numbers. I can solve this problem by using en-US culture but that has other implications that I cannot accept.
What can I do ?

[Maya]

Hi Lars,

You may set the CurrentCulture and CurrentUICulture of your application. Thus the grid will be displayed and exported correspondingly to the required settings of this culture:

public MainWindow()
        {
            Thread.CurrentThread.CurrentCulture = new CultureInfo("da-DK");
            Thread.CurrentThread.CurrentUICulture = new CultureInfo("da-DK");

            InitializeComponent();
        }

 

Best wishes,
Maya
the Telerik team

[HotlineOrbicon]

The XML export issue arise when using da-DK culture on the thread and although using en-US culture on the thread does solve the XML export issue, it creates other issues. I was hoping for a way to set en-US culture locally on the ExportTelerikGridDataUserControl but other solutions are welcome.

[Maya]

Hello Lars,

Generally, my suggestion was to define the Dutch culture as the default one for your application. Thus, when exporting the grid, the corresponding settings will be applied. Please take a look at the sample attached for a reference. Is this approach not appropriate for you ? If not, may you provide a bit more information about your specific requirements and settings ? Is ExportTelerikGridDataUserControl a custom control deriving from RadGridView ? What is the culture you want to use in your application ? Do you want to change it only when exporting ? 

Greetings,
Maya
the Telerik team