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

7 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

Public
Dmytro Zvazhii Flexmonster 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

Public
Jaffrezic September 11, 2018

Hi Dmytro
It works fine
Thanks

Please login or Register to Submit Answer