Start Building Professional
Web Apps Today

setNumberFormat

I have my number format set using:

<call command="setNumberFormat">
<param>€0,000.00</param>
<param>6</param>
<param>,</param>
<param>.</param>
</call>

So a number such as $6.6 (US) shows properly as €6,6 (Euros) but when I go into edit mode it changes it to (6.6) I need it to stay as 6,6 in edit mode. I did see some quick solution to do a replace of the "." but I may use it to do US $ as well so it needs to read from the column format that I specify.

In the JavsScript delimiter between fractional and integer is dot.To change this behaviour you can implement custom eXcell type. Please see more information here http://dhtmlx.com/docs/products/dhtmlxGrid/doc/articles/Custom_excell_creation.html#grid_cexc