Sorting of Numbers

Suite and Optimus Suite 5
#1

Hi,



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,

Caddy

#2

There 3 ways to resolve problem
a) use end|ron column type and setNumberFormat ( pro only )
    dhtmlx.com/docs/products/dhtmlxG … #grid_cexc

#3

Tnks for the quick response !!