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

[Giampiero]

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 ?

[Scintilla Arul Jothi Raj]

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. 

Sample link: https://www.syncfusion.com/downloads/support/forum/147727/ze/my-app-533684745 

Screenshot: 

 

 

 

Please let us know if you have any concerns. 

 

Regards, 

Scintilla A