asked on December 30, 2024
Hello,
If I put a format on a number field, it gets treated as string in Excel export. How do I stop that?
Thanks
Sri
Senior Developer
TeleBright
⋅ December 30, 2024
Hello Sri,
Thank you for reaching out to us.
If you are using the customizeCell method to format a number field, the number will be treated as a string when exported. To display these values as numbers in the exported Excel file, we recommend setting the useCustomizeCellForData property of the exportTo API call to false. This way, the values will not be formatted but presented as numbers in Excel. Please check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/xuoyk0qf/.
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
