hughxie said:

hughxie said:

hi,

I having trouble freezing columns when 'rownumbers: true'. Only column headers are frozen, not data. Currently, the only way is turning off rownumbers. Not sure if this is a bug. If yes, is there a work around?

Thanks in advance.

Just want to provide more info. it seems work after I sort one of the column. Any way do this without sorting? Here is my code:

            myGrid.jqGrid({
                data: mydata,
                datatype: 'local',
                colModel: [{name:'NAMESPACE', index:'NAMESPACE', width:130,frozen:true},
         {name:'SOURCE', index:'SOURCE', width:130,frozen:true},
         {name:'NAME', index:'NAME', width:130,frozen:true},
         {name:'EXPECTED_ARRIVAL', index:'EXPECTED_ARRIVAL', width:130,formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         {name:'REGISTRATION', index:'REGISTRATION', width:130,cellattr: function(rowId, tv, rawObject, cm, rdata) {
         return colorCode(rawObject.REGISTRATION_STATUS);
        },formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         {name:'ETL_STARTED', index:'ETL_STARTED', width:130,formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         ...]
    viewrecords: true,
                rownumbers: true,
                sortorder: "desc",
                height: 500,
                scrollOffset: 0,
                pager: '#pager',
                rowNum:200,
                rowList:[200,400],
                caption: "Zinc Feeds Status for COB Date 2012-06-11 (PROD)"
            });
           
           jQuery("#list").jqGrid('setFrozenColumns');

add reloadGrid seems to resolve the issue:

myGrid.trigger('reloadGrid');

hughxie said:

hi,

I having trouble freezing columns when 'rownumbers: true'. Only column headers are frozen, not data. Currently, the only way is turning off rownumbers. Not sure if this is a bug. If yes, is there a work around?

Thanks in advance.

Just want to provide more info. it seems work after I sort one of the column. Any way do this without sorting? Here is my code:

            myGrid.jqGrid({
                data: mydata,
                datatype: 'local',
                colModel: [{name:'NAMESPACE', index:'NAMESPACE', width:130,frozen:true},
         {name:'SOURCE', index:'SOURCE', width:130,frozen:true},
         {name:'NAME', index:'NAME', width:130,frozen:true},
         {name:'EXPECTED_ARRIVAL', index:'EXPECTED_ARRIVAL', width:130,formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         {name:'REGISTRATION', index:'REGISTRATION', width:130,cellattr: function(rowId, tv, rawObject, cm, rdata) {
         return colorCode(rawObject.REGISTRATION_STATUS);
        },formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         {name:'ETL_STARTED', index:'ETL_STARTED', width:130,formatter:'date', formatoptions:{ srcformat:'Y-m-d H:i:s', newformat:'Y-m-d h:i A', defaultValue: '-' }, sorttype: "date", datefmt: 'Y-m-d h:i A'},
         ...]
    viewrecords: true,
                rownumbers: true,
                sortorder: "desc",
                height: 500,
                scrollOffset: 0,
                pager: '#pager',
                rowNum:200,
                rowList:[200,400],
                caption: "Zinc Feeds Status for COB Date 2012-06-11 (PROD)"
            });
           
           jQuery("#list").jqGrid('setFrozenColumns');

I having trouble freezing columns when 'rownumbers: true'. Only column headers are frozen, not data. Currently, the only way is turning off rownumbers. Not sure if this is a bug. If yes, is there a work around?

Thanks in advance.