asked on June 21, 2018
Hi
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/
Regards
Franck
⋅ June 21, 2018
Hi Franck,
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.
Kind regards,
Iryna
⋅ June 22, 2018
Hi Iryna
Yes, It's a critical issue for us, because our customers export in excel format and the grand total export is not ok.
Kind regards,
Franck
⋅ June 27, 2018
Hi Franck,
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.
Kind regards,
Illia
Flexmonster Team
⋅ June 27, 2018
Hi Illia
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.
Regards
Franck
⋅ July 3, 2018
Hi Franck!
Thank you. We have replied via email.
Kind regards,
Illia
⋅ September 11, 2018
Hello Jaffrezic,
We are glad to inform you that the latest version of the component includes the update which allows exporting customized cells to Excel. You are welcome to try it.
Let us know if everything works fine for you.
Regards,
Dmytro
⋅ September 11, 2018
Hi Dmytro
It works fine
Thanks
