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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:





147727 Sep 22,2019 11:58 AM UTC Sep 23,2019 12:46 PM UTC Angular - EJ 2 1
Tags: PivotGrid
Asked On September 22, 2019 11:58 AM UTC

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 [Syncfusion]
Replied On 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 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon