Price column formating

Discontinued products Uncategorized discussions
#1

Hi Team,



I am using price column in grid.I want to format the value of column as $12,300.00

And also I am using mygrid.setColSorting(“int”) and filter as #numeric_filter.

The sorting and filtering should work in this case.



Thanks,

-Agile

#2

You need to set column as “edn” instead of “price” and use
grid.setNumberFormat("$0,000.00",0)

In such case you can provide raw numbers in origianal dataset - they will be correctly formated and still be available for int-like sorting|filtering.