Footer is treated as string values (because of possible text, etc), which make sense. However I would like to export footer as numbers. I know I can post proces workbook on excelExport event, but I need some clarifications. I would need to access to agregates of exported data. Is is possible? Or instead of accessing e.data property is better to get values directly from data source.
1 Answer, 1 is accepted
0
Accepted
Hello Marcin,
If the aggregates will be only numbers with no text, then the cell value can be parsed to int and then used for additional custom calculations.
I made an example where I added 20 to the aggregates value:
https://dojo.telerik.com/IBEyu
If there is text in the footer then a custom logic has to be used to subtract only the number part from the text in order to parse it.
Regards,
Stefan
Progress Telerik
If the aggregates will be only numbers with no text, then the cell value can be parsed to int and then used for additional custom calculations.
I made an example where I added 20 to the aggregates value:
https://dojo.telerik.com/IBEyu
If there is text in the footer then a custom logic has to be used to subtract only the number part from the text in order to parse it.
Regards,
Stefan
Progress Telerik
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.