Get Free Trial
Get Free Trial

Issue when export to excel with customize some cell

Jaffrezic asked on September 9, 2019

Hi,
I used the customizeCell for customize some cells, but when I export to excel the format for changed cells is not correct
see screenshot
and exemple on fidle : https://jsfiddle.net/s1c28nzp/
 
Thank
 
Franck

Attachments:
exporttoexcel.png

4 answers

Public
Vera Didenko Flexmonster September 9, 2019

Hello,
 
Thank you for writing to us.
 
We would like to explain that cell data which is customized with the customizeCell() API call is exported as a string.
The reason for this is that we cannot predict the data type of customized cells for all cases.
Therefore, we generalized all customized cells to be of type string.
 
In your case, when exported to Excel, such cells can’t be used in a formula because they are of type string, not number.
 
Please let us know if you have any questions.
 
Best Regards,
Vera

Public
Jaffrezic September 10, 2019

Hi Vera
Thank for your answer.
But for us it’s a real problem.
Have you a solution for resolve this issue ?
Franck

Public
Vera Didenko Flexmonster September 10, 2019

Hello, Franck,
 
Thank you for your response.
 
Our development team has looked into your case with more detail.
The fix will be available in the minor release version with the ETA October 7th.
 
You are welcome to contact us in case of questions.
 
Best Regards,
Vera

Public
Vera Didenko Flexmonster October 8, 2019

Hello, Franck,
 
We are happy to let you know that now if the data cell was changed with customizeCell approach and the new value also has type number, it will be exported to Excel as a number.
 
This is available in the 2.7.16 version of Flexmonster: https://www.flexmonster.com/release-notes/.
 
You are welcome to update the component.
Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please contact us in case any questions arise.
 
Best Regards,
Vera

Please login or Register to Submit Answer