CSV grid not sorting

I too am having the same difficulty as a previous poster (link: dhtmlx.com/docs/products/kb/ … tml?q=8762). Reposting here because it looks like my addon question wasn’t seen. I tried the advice listed, but no matter what I try, am unable to sort.

My first column is unique, and whether I try enableCSVAutoID or not, results are the same. No sorting.



plain.csv:

,HEADER1,HEADER2,HEADER3,HEADER4,HEADER5,HEADER6

,a_item1,a_item2,a_item3,a_item4,a_item5,a_item6

,b_item1,b_item2,b_item3,b_item4,b_item5,b_item6

,c_item1,c_item2,c_item3,c_item4,c_item5,c_item6

,d_item1,d_item2,d_item3,d_item4,d_item5,d_item6

,e_item1,e_item2,e_item3,e_item4,e_item5,e_item6

,f_item1,f_item2,f_item3,f_item4,f_item5,f_item6



grid code:

function createGrid()

{

mygrid = new dhtmlXGridObject(‘excelGrid’);



mygrid.setImagePath("…/js/dhtmlxGrid/codebase/imgs/");

mygrid.loadCSVFile(“plain.csv”);

//mygrid.enableCSVAutoID(true);

mygrid.enableCSVHeader(true);



mygrid.setInitWidths(“130,130,130,130,130,130”);

//mygrid.setColAlign(“left,left,left,left,left,left”);

//mygrid.setColTypes(“ro,ro,ro,ro,ro,ro”);

mygrid.setColSorting(“str,str,str,str,str,str”);



mygrid.enableAutoWidth(true,800,799);

mygrid.enableAutoHeight(true,500,499);



mygrid.setSkin(“modern”);

mygrid.init();



mygrid.load(“plain.csv”,“csv”);

}

The problem caused by double initialization.
You specifying some parameters through javascript and structure of grid headers defined in CSV in same time.
Grid can be configured from js script , or directly from datasource, but not the both in same time. In you case grid configured on client side, and after that reset because of header line in CSV ( and related js command )

To solve issue you can
a) define header in js code and remove mygrid.enableCSVHeader(true); line

or
b) reorganize existing js code as
mygrid.loadCSVFile(“grid.csv”,function(){
mygrid.setColSorting(“str,str,str,str,str,str”);
});

In such case , sorting settings will be applied to grid only after data loaded ( so they will not be reset by header line in CSV )