Sorting stops working correctly for table with more than 257 entries

artmus

Hello,
I have an issue with sorting my table, which contains lots of entries. Each object "g" contains a representation for how to display the value (a formatted number with "." as the thousands seperator, "," for decimal and "€" as the currency symbol) and a property "raw", which contains the number value for sorting the table.

When having less than 258 entries, the sorting works fine. But with more than that it starts sorting incorrectly.

Test-case: http://live.datatables.net/nihohoto/1/edit
Right now there are 258 entries in this test case. If you remove one of them, the table starts sorting correctly.

Any workarounds for this issue?

Thanks.

allan

You need to set the type option to raw as well. Otherwise DataTables will be doing type detection on the display string whereas in this case you want it on the raw data: http://live.datatables.net/nihohoto/3/edit .

Allan

allan

I should mention that there is another option - you can tell DataTables to use a comma for the decimal place: http://live.datatables.net/nihohoto/4/edit .

Allan