Grid Number Format for 0

Suite and Optimus Suite 5
#1

Hi, All

There is a question for grid setNumberFormat() function.

I’ve use the function like this:
mygrid.setNumberFormat(“0,000.00”,index,".",",");

Is there any way to display the cell as ‘0’ which value is 0 but not ‘0.00’?

Thanks for any help.

#2

If you have specified format, it will be applied to the all cells. There is no way to define exception rules.

But you can define per-cell types in data xml, which will allow to ignore formatting rules on some cells

0
0

With above xml, first row will be formatted, while second will be preserved unchanged.