Hi.
I'm exporting a grid to excel. GridGroupFooter items with totals exports the amounts as I expect (with format), but with GridDataItems exports the amounts without format. Do I have to do anything special for exporting normal item data lines?
I append a screenshot with sample data.
Thx.
I'm exporting a grid to excel. GridGroupFooter items with totals exports the amounts as I expect (with format), but with GridDataItems exports the amounts without format. Do I have to do anything special for exporting normal item data lines?
I append a screenshot with sample data.
Thx.
1 Answer, 1 is accepted
0
Hello,
You can set the desired formatting manually as explained here:
Word/Excel export (HTML-based)
I recommend you examine the following sections:
- Using ItemCreated/ItemDataBound
- Number formats / Formulas
- ExcelExportCellFormatting event
Depending on your scenario you can use ItemCreated, ItemDataBound or ExcelExportCellFormatting event.
Kind regards,
Daniel
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.
You can set the desired formatting manually as explained here:
Word/Excel export (HTML-based)
I recommend you examine the following sections:
- Using ItemCreated/ItemDataBound
- Number formats / Formulas
- ExcelExportCellFormatting event
Depending on your scenario you can use ItemCreated, ItemDataBound or ExcelExportCellFormatting event.
Kind regards,
Daniel
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.