change default group and decimal permanent.

Suite and Optimus Suite 5
#1

Hi,

Is there a way to change change the default decimal and group separator?
Here in Belgium we use the “.” as group separator and the “,” as decimal separator.

We always load the data in a grid with that way of writing.
Now and then we reuse a grid but hiding some columns so we cannot use the numberFormat as a column is one moment an amount and the second time it can be a product ID.

If we want to use the build-in functions for making a sum of a column it only uses the numbers till it finds the first “.”
So we were looking if it’s possible to change the default settings.

Anyway thx alot for your time and give the developers a big thumbs up.

#2

Please, try to use the following:
myGrid.i18n.decimal_separator="." //char used as decimal separator
myGrid.i18n.group_separator=’,’ //char used as groups part separator

#3

oke thx will try that in my next report.