Posted 24 June 2025, 4:49 am EST
In react , how to change the format of a cell from a number to text.
I was using function formatter(“@”), but some times working, some times not working.
Forums Home / Spread / SpreadJS
Posted by: 15363238 on 24 June 2025, 4:49 am EST
Posted 24 June 2025, 4:49 am EST
In react , how to change the format of a cell from a number to text.
I was using function formatter(“@”), but some times working, some times not working.
Posted 25 June 2025, 2:33 am EST
Hi,
As per my understanding, you want to format numbers as text.
You’re correct that using the ‘@’ text formatter is the right approach. I tested it on my end, and it works consistently as expected. Please refer to the attached GIF “Steps.gif” and this sample for reference:
https://jscodemine.mescius.io/share/KiGZfm0fMUyFOekQvy_p-g/?defaultOpen={“OpenedFileName”%3A[“%2Findex.html”%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.jsx"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.jsx"}
Since you’re experiencing inconsistent results, it would be helpful if you could share a minimal working sample that reproduces the issue, or modify the above sample to demonstrate the problem. Also, providing a GIF or video showing the behavior would assist in troubleshooting more effectively.
Regards,
Priyam