We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

fr Culture with thousand separator and coma for decimal

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

import { setCulture, loadCldr } from "@syncfusion/ej2-base";

import frCurrencyData from '../../cldr-data/main/fr/currencies.json';
import frTimeZoneNames from '../../cldr-data/main/fr/timeZoneNames.json';
import frNumbers from '../../cldr-data/main/fr/numbers.json';
import frCaGregorian from '../../cldr-data/main/fr/ca-gregorian.json';
import supplementalCurrencyData from '../../cldr-data/supplemental/currencyData.json';
import supplementalNumberingSystems from '../../cldr-data/supplemental/numberingSystems.json';

loadCldr(
frCurrencyData,
frTimeZoneNames,
frNumbers,
frCaGregorian,
supplementalCurrencyData,
supplementalNumberingSystems
);

setCulture("fr-FR");

6 Replies

SP Sangeetha Priya Murugan Syncfusion Team April 6, 2023 11:45 AM UTC

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



NI Nix April 11, 2023 09:04 PM UTC

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    



SP Sangeetha Priya Murugan Syncfusion Team April 12, 2023 11:16 AM UTC

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.



NI Nix April 12, 2023 04:42 PM UTC

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



SP Sangeetha Priya Murugan Syncfusion Team April 14, 2023 07:23 AM UTC

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



SP Sangeetha Priya Murugan Syncfusion Team September 20, 2023 10:23 AM UTC

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


Loader.
Up arrow icon