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.
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.
That worked great.