Please, sorting problem, what�s wrong!!! ????? :o(

Discontinued products Uncategorized discussions
#1

I have this code, the grid loads ok from a table, but when the user click the headers to sort the grid, doesn�t sort correctly. I have modifiy the setColSorting property but don�t fix the problem.

Thnks for any help.































    

    

    

    

    

    

    



















































































































































Suc … Venta Bruta Descuentos Se�a Vales Total
1 Client S 320.640,00 25.564,00 -103,00 -304,00 294.672,00
2 Client E 338.684,00 37.771,80 0,00 -733,80 300.178,40
3 Client F 1.318.851,90 156.478,60 250,00 2.151,30 1.164.774,60
6 Client G 590.330,40 63.038,10 -50,00 -1.664,50 525.577,80
7 Client D 530.911,80 58.277,10 0,00 -27,90 472.606,80
8 Client C 1.087.387,70 136.431,20 160,00 -808,40 950.308,10
9 Client B 2.018.940,70 222.183,60 -1102,00 1.058,30 1.797.715,40
12 Client A 655.605,00 68.863,10 -101,00 -1.270,70 585.371,20
























#2

Actually sorting works correctly , but it threats values as strings , and event if you change your code to
    mygrilla.setColSorting(“int,str,int,int,int,int,int”);
the sorting will be still incorrect because you are using numbers with additional formatting, which can’t be correctly parsed by native parseInt functionality

#3

yes, if i put 585371,20 instead 585.371,20  ( without thousand separator) the sort works correctly.
And how i can format the column to have thousand separator ?  i have tried with  mygrilla.setColTypes(“ro,ro,price,price,price,price,price”); but don´t work :astonished:(
hey, sorry for my english, i hope you understand something  :astonished:)
thanks a lot

#4

You can have data in original HTML table as plain numbers and add comma separator as part of grid number formating functionality - please check attached sample

sample.zip (1.08 KB)