thousand separator (space) and decimal separator (.)

[Gauthier MAIROT]

Hello,

I'm french and I would like to display numbers with this options : 

• Thousand Separator : (
  space)
• Decimal Separator :  (.)
• grouping by 3

For example : 2,528,255.77 would become 2 528 255.77

How can I do this ?

Thanks.

[Sivamathi Natarajan]

Hi Barak, 

 

Thanks for contacting Syncfusion support. 

 

We have checked the reported problem at our end. But we are unable to reproduce the problem. So, we have prepared a sample to trigger pointClick event in pivot chart. Please check the below sample. 

 

Code Example: 

 

 <ejs-pivotview #pivotview id='PivotView' showFieldList='true' width='100%' height='450' 

      [displayOption]='displayOption' [dataSourceSettings]=dataSourceSettings [chartSettings]='chartSettings' (dataBound)='dataBound($event)'> 

    </ejs-pivotview> 

 

pointClick(args: any): void { 

    console.log(args); 

  } 

 

  dataBound(args: any): void { 

    this.pivotObj.chart.pointClick = this.pointClick.bind(this); 

  } 

 

 

Sample: https://stackblitz.com/edit/angular-k6tgcx-bravyh?file=app.component.ts 

 

We hope the above sample meets your requirements. 

 

Regards, 

Sivamathi. 

[Gauthier MAIROT]

Hi, 

I think misundertood each other...

In this following example : https://ej2.syncfusion.com/javascript/demos/#/material/pivot-table/olap.html

For bikes sales, we have :

I would like format numbers like this :

Thousand separator with space, decimal seperator with . , grouping by 3.

Regards, 

[Sivamathi Natarajan]

Hi Gauthier, 

 

Sorry for the inconvenience caused. 

 

Please refer the respective *.json files to load the required currency. Meanwhile, we have prepared a sample for your reference with French currencies. Please check the below sample and UG. 

 

Sample Link: https://stackblitz.com/edit/1nnfuw-adbfh9?file=index.ts 

 

UG:  https://ej2.syncfusion.com/documentation/pivotview/globalization-and-localization/#globalization 

 

Please check the below screenshot. Here you can customize separators and grouping. 

 

 

 

As per your requirement, you can change the decimal/thousand separators and grouping in numbers.json file. Please check the below screenshot for your reference. 

 

 

Note: The decimal points will change only when the system culture is changed to French. Otherwise, it shows the values in US culture.  

 

 

Regards, 

Sivamathi.