digit grouping in grid

[simplewebMember]

hi there,

I’m using jqxgrid, and have editable cells with numeric values. Not sure how to format them with comma, like instead of 1000, make it 1,000. Here is a sample of data cell that I have:

….
{ text: ‘Price’, datafield: ‘decPrice’, width: 90, cellsalign: ‘right’, columntype: ‘numberinput’,
createeditor: function (row, cellvalue, editor) {
editor.jqxNumberInput({ decimalDigits: 0, digits: 10 });
}
},…..

I want to be able to group the numbers with comma when it is displayed and when in edit mode. Is this possible?

thanks

[Peter StoevKeymaster]

Hi,

In edit mode, the “comma” will not be displayed. For formatting the text in the cells, you may set the “cellsformat” property to a value like ‘f0’.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts