Posted 8 July 2019, 7:43 pm EST - Updated 3 October 2022, 1:48 am EST
Hi everyone.
I’m trying to figure it out how to change cell formatting in angular wrapper of spread sheet.
I’ve seen that changing globalization doesn’t suit my needs.
If the standard numeric format is "4,294,967,295.00 ",
I’m searching a way to make it like this “4.294.967.295,000”.
I’m not very practice with spread sheet and Angular wrapper doesn’t publish all the options described on sheets documentation.
Since I haven’t reached the goal to set globalization, I’ve tried to use gc-column formatting:
<gc-column [headerText]="'Gennaio'"
[width]="75"
[formatter]="'#,##0'"
[dataField]="'Gennaio'">
</gc-column>
The result has “,” has thousands separator and “.” as decimal separator.
Can you suggest me a way to invert separators? Or maybe give me an help how to use a custom formatter with Angular wrapper?
Thanks in advance.