I'm a bit unsure of how to handle localization in regards to the numbers and dates within a radGrid.
This is our scenario. I have created the reports and tested them in the U.S. When the user runs the report on his workstation in Germany and exports the data to Excel the numerical data is displaying in English format.
ie. 1,344.00
As opposed to the German format which would be: 1.344,00
Currently my data is displaying on a German server as 1,344.00. If I go to the German server, open up the excel file that was exported and click on the cell that currently displays 1,344.00. I can then set that cells format to number and check the checkbox for: "use 1000 separator (.)". Then I have to re-type the number into the field. So I type in 134400 and hit enter. Then the value is displayed as 1.344,00. Which is what I want.
So the million dollar question. How do I export my data such that the formatting is like this?
This is an urgent issue so any help is greatly appreciated.
Thanks,
Julian