customizeCell is not applied when exporting to Excel

posted on December 7th, 2017

Answered

Alan asked on December 7, 2017

Hi,
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.
Thanks,
Alan

2 answers

Public

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 https://www.flexmonster.com/doc/managing-data-presentation-json

Please let me know if this approach works for you.

Kind regards,
Iryna

Public

Alan ⋅ December 7, 2017

Hi Iryna
That worked great.

Thanks

customizeCell is not applied when exporting to Excel

2 answers

Please login or Register to Submit Answer