Number format in column


#1

In Poland we do not use ‘.’(dot) as decimal separator, but we use ‘,’ (comma). When I provide proper format with JSON then in footer “sum” is not working.
How can I have both? In 5.0 there was numberFormat option. In 7.0 docs I cannot see such.


#2

You may apply a custom format for your data presentation in the column using the templates:
https://docs.dhtmlx.com/suite/grid__customization.html#addingtemplatetocells


#3

Thank you, it worked for the column cells, however the Footer with sum is showing always with ‘.’ (dot) and 3 digits after it. So 400,00 looks like this: 400.000 - how can I format the value in footer?


#4

Since the dhx.Suite 7.1 update there is a possibility to set the number format to your cells:
https://docs.dhtmlx.com/suite/grid__configuration.html#formattingcolumns
it also works for the footer