This is a migrated thread and some comments may be shown as answers.

Cannot maintain the % formatting when exporting to Excel (HTML option)

1 Answer 10 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Peter From LA
Top achievements
Rank 1
Peter From LA asked on 21 Aug 2015, 07:41 AM

I have a grid which contains a column with DataFormatString="{0:0.00%}"...

 All looks great in the grid, but when I export to Excel I see the 1.00 instead of 100% and 0.25 instead of 25%.

Is there a way to transfer the formatting to the Excel file?

1 Answer, 1 is accepted

Sort by
0
Kostadin
Telerik team
answered on 26 Aug 2015, 05:55 AM
Hello Peter,

I am not sure which export format you are using but in case this is the default one then I would recommend you to examine the following help article for additional information about number formats.

Regards,
Kostadin
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Grid
Asked by
Peter From LA
Top achievements
Rank 1
Answers by
Kostadin
Telerik team
Share this question
or