Sorting of Numbers


I have a question regarding the sorting of values.

I our database we have “bigger” numbers stored. The issue now is that

I fetch the formatted out of the database.

f.e. dbval : 111222999 -> 111.222.999

This makes value the easier to read for the users.

But : If I click on the column heading, the sorting doesnt work anymore

(because the grid treats it as a string ?? )

Does anybody had also this problem and fixed it ??

Thanks in advance,


There 3 ways to resolve problem
a) use end|ron column type and setNumberFormat ( pro only ) … #grid_cexc

Tnks for the quick response !!