French number formatting

Suite and Optimus Suite 5
#1

Hi!

I have a problem witch number formatting. French formatting doesn’t work at all.
I create such column in xml:

and it returns undifined format. Maybe I should attach something?
Can anybody help?

Than ks

Asia

#2

If you need to change decimal and group separators you should use setNumberFormat() method:

mygrid.setNumberFormat(“0,000.00”,index,","," ");

docs.dhtmlx.com/doku.php?id=dhtm … c_values&s[]=number&s[]=format

#3

in SetNumberFormat I need to define index. I load grid dynamically and I would like to define format while loading xml. When I use format=“0,000.00” id does work,
but when I use format=“0 000,00” it doesn’t.

#4

You have to use “,” as group separator and “.” and decimal separator in “format” attribute. It not possible to change default group and decimal separators with ‘format’ attribute.
As a work around you can call setNumberFormat method from xml:

0,000.00 $index , &nbsр;

docs.dhtmlx.com/doku.php?id=dhtm … n_from_xml

#5

I found solution.
I implement
grid.i18n.decimal_separator=","
grid.i18n.group_separator=" ";
for the whole grid and set format I need for each column in xml.
:smiley:

#6

Olga - thanks for Your solution.
Asia