Hi,
I have a grid with a column that contains values such as: 001 , 012 , 015 when I exprt to excel the pasted values are: 1,12,15.
How can I keep the original values when exporting to excel? (As string)
Thank you in advance,
What data type is the column in the grid? My guess is that it's a numeric type and you are using the Format property on the column to format it. Or possibly the MaskInput property.
The Formats in Dotnet are not the same as the ones in Excel. So if you are using Format, then what you should do is handle the InitializeColumn event of the UltraGridExcelExporter and translate the format into an Excel format and assign the format to the excel column. If I recall, the event args will expose this for you.
Another option would be to handle the CellExported event of the UltraGridExcelExporter and format the value yourself and write it into the cell how you want it.
Thanks Mike. This is perfect.