1. Home
  2. Forum
  3. Angular - EJ 2
  4. Change the decimal separator to ',' instead of '.'

Change the decimal separator to ',' instead of '.'

Hello,

Could you please tell me how can I change the decimal separator to comma instead of dot or point which is set by default? 

I am using the Spreadsheet v. 19.4.43.

Best Regards,

Ignacy Mielniczek


8 Replies
SP Sangeetha Priya Murugan Syncfusion Team March 25, 2022 12:28 PM UTC

Hi Ignacy, 

 
We have checked your query and please confirm the below details to proceed further. 

 
1. whether you need to change the decimal separator in en-US default culture? or you need to load another culture. 
2. If you load another culture means, please refer the KB link to load the culture files for proper formatting. 
3. Please share the details, why you need to change the decimal separator.  
4. Please share the detailed description of your requirement. 

 
Could you please check this and get back to us with above requested details, based on that we will check and provide you a better solution. 

 
Regards, 
Sangeetha M 


IM Ignacy Mielniczek March 31, 2022 01:50 PM UTC

Hello Sangeetha,

Thank you very much for a quick response. I have done the following things just like they are shown in the culture setting example which you have sent earlier:

  1. Loaded the currencies, cagregorian, numbers, timeZoneNames, numberingSystems from cldr-data library.
  2. Set the culture to French.
  3. Set the currency to Euro.
  4. Loaded a French culture to L10n.
  5. Set locale to French in Spreadsheet Component.
Unfortunately, it is not working as expected. Whenever I try to directly calculate in Spreadsheet Component, the sum of two cells which have the decimals separated by commas in it, returns 0. However, it is calculating correctly for the decimals separated by dots or points.

Also, we are using ASP.NET Core backend service and I have successfully set the culture to French over there. When I generate the PDF file from the same cells described above using this backend service, the generated files have correctly calculated cells in it. 

PS. I have attached the example screenshots.

Best Regards,
Ignacy Mielniczek

Attachment: Decimals_sum_d626b177.zip

SP Sangeetha Priya Murugan Syncfusion Team April 11, 2022 11:32 AM UTC

Hi Ignacy,


We have checked your reported issue with the French culture by loading the cldr-data and it works properly in our end. For your convenience, we have prepared the sample. Please find the link below.


Sample Link: https://stackblitz.com/edit/angular-hhanef-e49xyw?file=app.component.ts


Could you please check the above sample and replicate your issue with the above sample and sent back to us with video demonstration. Based on that we will check and provide you a better solution quickly.


Regards,

Sangeetha M


IM Ignacy Mielniczek April 11, 2022 01:14 PM UTC

Hello Sangeetha,

I just wanted to point out that in the example which you sent me the calculation of sum of decimals separated by commas are not working as expected even after loading the French culture, it just returns 0. But for the decimals separated by dots the sum function calculates and returns 0.50 as expected.

I have attached an example screenshot.

Best Regards,

Ignacy Mielniczek 


Attachment: French_Culture_sum_not_working_abc5f731.zip

SP Sangeetha Priya Murugan Syncfusion Team April 12, 2022 02:02 PM UTC


Hi Ignacy,


We have checked your reported issue and this issue is related with sub component of the Spreadsheet and we have forwarded this query to concern team.  And we will update you the further details on April 18th, 2022.


Regards,

Sangeetha M


SP Sangeetha Priya Murugan Syncfusion Team April 20, 2022 01:32 PM UTC

Hi Ignacy,


We have faced some complexities while validating your reported issue with specific culture. So, we will update you the further details on April 22nd, 2022. We appreciate your patience until then.


Regards,

Sangeetha M


IM Ignacy Mielniczek April 20, 2022 03:36 PM UTC

Hello Sangeetha,


Thanks for the update.


Best Regards,

Ignacy Mielniczek


SP Sangeetha Priya Murugan Syncfusion Team April 26, 2022 01:22 PM UTC


Hi Ignacy,


We suggest you to apply the number format for numbered cells to avoid this issue in your end. And we have prepared the sample based on our suggestion with formula calculation. In this we have applied the number formats for F column and apply the formula for F31 cell please find the link below.


Sample Link: https://stackblitz.com/edit/angular-hhanef-nop9rs?file=app.component.ts


Could you please check the above link and get back to us, if you need any further assistance on this.


Regards,

Sangeetha M


Loader.
Up arrow icon