I changed value grand total row with customizeCell
When I export with format csv the value for Grand Total row is ok but when export with excel the value is not correct
See : http://jsfiddle.net/est0yrf1/
Thank you for posting your question on the forum.
This is the known aspect of
customizeCell feature that the changes made to numeric cells in the table are not represented in the file exported to Excel. This is because numeric values are exported to Excel not as string labels, but as numbers with the format applied on top of them. At the same time,
customizeCell feature changes text labels in cells and does not change the underlying values.
Please let us know how critical it is for you to see the string labels defined via
customizeCell in exported Excel file.
Yes, It’s a critical issue for us, because our customers export in excel format and the grand total export is not ok.
Please note that we have sent you an email with some details regarding this issue. Would appreciate if you could have a look and share your thoughts.
In our project
First : we need to export to excel with the value of GrandTotal display in screen even if grand total is changed with customizeCell.
Second : We need differentiate value 0 and value null even for calculated values.
Thank you. We have replied via email.