Sort like Float, Display like String

[djchou]

I have a qgrid that contains $ amounts that I would like to have displayed with commas separators but if I change the value types from float to string, the columns do not sort properly. How can i get around this?

[djchou]

For what its worth, I solved this by changing the qgrid.js file to apply a custom formatter for the columns based on name, accessible under cur_column.name. This allowed the sort to be based on the float values and the display to include commas.