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
close icon

How to put the number format (. thousands separator) (, decimal point) in PivotGrid

Hi we're using a PivotGrid for show data. We want show the number with the format

200.000,55 (. thousands separator) (, decimal point)

We use format: "C2", currency: "EUR"  in the formatSettings but the thousands separator and the decimal point appears inverted.

We have even set setCurrencyCode('EUR') without luck.

What can we do ?

1 Reply

SA Scintilla Arul Jothi Raj Syncfusion Team September 23, 2019 12:46 PM UTC

Hi Giampiero, 
Currently we don’t have any support to change currency format (Because, it is working based on the respective culture), however you can manually change the currency format in es culture number format in number.json file. please for refer below code snippet for change currency format. 
"symbols-numberSystem-latn": {  
          "decimal": ",",  
          "group": ".",  
Meanwhile, we have prepared a sample for your convenience. 
Please let us know if you have any concerns. 
Scintilla A 

Live Chat Icon For mobile
Up arrow icon