Issue when export with excel

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

5 answers

Public
Iryna Kulchytska Flexmonster 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

Public
Jaffrezic 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

Public
Illia Brazhko Flexmonster 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

Public
Jaffrezic 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

Public
Illia Brazhko Flexmonster July 3, 2018

Hi Franck!
 
Thank you. We have replied via email.
 
Kind regards,
Illia

Please login or Register to Submit Answer