🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

customizeCell is not applied when exporting to Excel

Alan asked on December 7, 2017

I have a customizedCell function that converts an integer into a time duration string e.g 01:23:00 i.e hh:mm:ss. This works when flexmonster is rendered in the web page. But if I export it to Excel the column has the raw value e.g 204346 not my string. How can I get it to work for excel.

2 answers

Iryna Kulchytska Iryna Kulchytska Flexmonster December 7, 2017

Hi Alan,
Thank you for posting your question.
Please note that customizedCell function is not used in full during the export to Excel.
We would like to recommend you using our "time" data type for JSON. It converts automatically an integer into a time duration string and is exported to Excel properly. Here is a small sample of "time" data type: http://jsfiddle.net/flexmonster/n2gLckxj/. More information on how to define data types in JSON can be found in the documentation http://www.flexmonster.com/doc/data-types-in-json/
Please let me know if this approach works for you.
Kind regards,

Alan December 7, 2017

Hi Iryna
That worked great.

Please login or Register to Submit Answer