Hi.
Anyone have any ideas how to enforce locale sensitive date time formats in data exported from the grid control to excel. I guess what I am asking is what format string would I need to supply in order that Excel used the *date formats which are locale sensitive? I need to know this for Date, Date Time and Time formats?
Any clues....
Hi,
What kind of problem are you having here? What version of the controls are you using?
If you are using the UltraGridExcelExporter, then no formatting is exported at all. It cannot be, because DotNet formats are not the same as excel formats and there's no way to the grid or the exporter can translate any format you applied to the grid column into an appropriate excel format.
To handle this, there's an InitializeColumn event on the UltraGridExcelExporter component which you can handle in order to examine the format on the grid column and create an appropriate format for the Excel cells.You can often set one to the other, but not always.
To be honest I'm not sure how excel exportation factors into this, but generally speaking if you stay away from specifying formats or masks, the default ones we provide are automatically culture-appropriate.