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
⋅ January 7, 2025
Hello Sri,
Hope you are having a great week!
We were wondering if you had a chance to check the suggested approach. Could you please confirm if it works for you?
Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ 10 hours ago
Hello,
Hope you are doing well.
Just checking in to ask if you had a chance to check the suggested approach. Could you please confirm if the useCustomizeCellForData property works for you?
Looking forward to hearing from you.
Kind regards,
Nadia
