Grid float cells sort problem

[andy8Participant]

Hello all,

I have a grid with cells formatted as floating numbers, populated via array (all numbers, no strings here). Some columns show a very strange sorting behavior, like

-29.07872
-31.72483
-34.86176
-54.39821
-6.42013
-7.00634
-7.24155

The fragments of my grid settings:

columns:[{ text: 'Max DD', datafield: 'a5',cellsalign: 'right', width: 70, cellsformat: 'F5' },{...},{...}]...
source: corrAdapter,
editable: true,
sortable: true,
columnsresize: true,
theme: theme,

What am I missing here? Actually, sorting works fine on other columns with value ranges <1, but not on that one.

Thanks

[andy8Participant]

Got it fixed – data type “float” in the data adapter was missing.

What will happen if we try to render a string in a column of “float” type? Will it revert to a string type for the whole column?

Thanks

[Peter StoevKeymaster]

Hi andy8,

You can render anything in a column, but you can have only one data type per column. Otherwise, you will not be able to correctly sort/filter the data column.

Best Regards,
Peter Stoev

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

[Author]

Posts