Hello,
Even if I have found similar threads about setting and load culture, I'am not able to set the proper culture for separator and decimal value. I would like numbers formatted like this '1 000 000,00'.
When I load culture in my react spreadsheet component, nothing happens. I found a tricky way to convert each cell, but if we use formula, it will not works.
Do you have any idea what I'm doing wrong?
Sincerely,
Nicolas
Hi Nix,
We suspect that you haven’t properly referred to the cldr-data packages in your application.
For your convenience, we have prepared the sample based on your requirement in fr culture. Please find the link below.
Sample Link: https://stackblitz.com/edit/react-r6kh4g-ncgcg8?file=data.js,index.js
Documentation Link: https://ej2.syncfusion.com/react/documentation/common/internationalization/
https://ej2.syncfusion.com/react/documentation/spreadsheet/global-local/
Could you please check the above link and get back to us, if you need any further assistance on this.
Regards,
Sangeetha M
Hi Sangeetha,
Thanks a lot for the quick reply. It's working perfectly. I don't know why but I also had to specify the number format
"# ##0" for the thousand separator to work with a space. Anyway it's exactly what I was looking for.
However I can not use formulas with coma for decimal, but I guess this is more a Javascript problem for mathematic operations rather than "cell representation" within the td element.
Thanks,
Regards
Nicolas
Hi Nix,
We have applied the formula with decimal separator (,) for decimal values in our previously shared sample and it works properly in our end. Please find the screenshot below.
Could you please share your issue replicable formula scenario in detail with video demonstration or screenshots. Based on that we can be able to check and provide you a better solution quickly.
Sure!
Here is an example from your stackblitz code.
if I use formulas with 2 cells for example it is working fine, but if I write number with coma as decimal in formula input it is not working.
But again it is perfectly fine like this.
regards
Nicolas
Hi Nix,
Please ignore the previous update; we shared the timeline incorrectly.
Currently we don’t have globalization support for our formula calculations in our spreadsheet. And we have considered this as a feature and the fix will be available in our Essential studio Volume 3 release. Which is scheduled to be rolled out in end of September 2023. We appreciate your patience until then. You can track the status of this feature using the link below from our feedback portal.
Feedback Portal Link: https://www.syncfusion.com/feedback/42871/provide-globalization-support-for-calculate-module-in-spreadsheet
Hi Nix,
We promised implementation of this feature in our Volume 3 release, but we are unable to carry through the implementation on the date promised. We will include this feature in any of our upcoming releases.
We regret any inconvenience this has caused and are sorry we cannot commit to a timeline for this implementation. You can track the status of the feature using the below feedback link.
Feedback Portal Link: https://www.syncfusion.com/feedback/42871/provide-globalization-support-for-calculate-module-in-spreadsheet