Hi !
In my grid there are decimal numbers like 4,5 and 13,6114 in the grid
I use the method SaveToXLS to export them to Excel. In Excel I get 4,5 and 136 114 !
My decimal separator is comma (,) in Regional settings.
If decimal separator is set to dot (.) I get correctly 4.5 and 13.6114
What is wrong here ? Our customers use the national setting comma
Is there away to configure how to use decimals in SaveToXLS ?
if using TAdvGridExcelIO, would that correct the problem ?
When using grid.SaveToXLS() all cells are exported as strings to Excel. This is irrespective of decimal/thousand settings.
For more control on how data is exported to Excel, please use TAdvGridExcelIO. See sample: http://www.tmssoftware.com/site/asg56.asp
Kind regards,
Nancy Lescouhier