Qaja Mohiddin
Top achievements
Rank 1
Rank 1
Qaja Mohiddin
asked on 13 Nov 2009, 10:48 AM
Hi,
I am dynamically creating the 'GridNumericColumn' Columns in the Grid.By using "DataFormatString" property I am convering to currency, Percentage formats. I am able to see the "$" and "%" symbol in Grid. But in the Excel sheet (after exporting Grid to Excel), those symbols are missing. Could anybody suggest me what would be the problem?
Thanks,
Malli
I am dynamically creating the 'GridNumericColumn' Columns in the Grid.By using "DataFormatString" property I am convering to currency, Percentage formats. I am able to see the "$" and "%" symbol in Grid. But in the Excel sheet (after exporting Grid to Excel), those symbols are missing. Could anybody suggest me what would be the problem?
Thanks,
Malli
1 Answer, 1 is accepted
0
Hello Qaja,
You can set the appropriate style on OnExcelExportCellFormatting event which is raised when RadGrid is exported to Excel (before the resulting document is rendered on the client). This event can be used for applying formatting to a cell. For instance adding numeric format to cell’s value by adding mso-number-format style attributes.
Regards,
Pavlina
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
You can set the appropriate style on OnExcelExportCellFormatting event which is raised when RadGrid is exported to Excel (before the resulting document is rendered on the client). This event can be used for applying formatting to a cell. For instance adding numeric format to cell’s value by adding mso-number-format style attributes.
Regards,
Pavlina
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.