Meenakshi Nagalingam
Top achievements
Rank 1
Rank 1
Meenakshi Nagalingam
asked on 05 Feb 2010, 01:22 PM
Hi,
I am using rad grid version 4.6.0.0. I am exporting data to excel using GridExcelExportFormat.Html format. The data is in 99-9999 format.
The issue is while exporting it converts this numeric data into Date format. I need to preserve this number-number format while exporting also.
If anybody know how to preserve the data format pls let me know.
Thanks in advance
1 Answer, 1 is accepted
0
Hello Meenakshi,
You could set the desired data type (string in this scenario) using the mso-number-format style. You can use ItemCreated event for that purpose.
Word/Excel export (HTML-based)
Export to excel not showing datetime cells correctly
Regards,
Daniel
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
You could set the desired data type (string in this scenario) using the mso-number-format style. You can use ItemCreated event for that purpose.
Word/Excel export (HTML-based)
Export to excel not showing datetime cells correctly
Regards,
Daniel
the Telerik team
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.