tony on checkbox formatter

Mon, 21 Feb 2011 20:34:34 +0200

Hello,

Let's think what is happen.

Q.What is formatter?

A. Formatter represets the data in new way into the grid and nothing more. They do not change the grid internal data or exactly if its visible data is changed under some condition it will not reflect the futute data processing.

Note that by defaule the disabled feature for the checkbox is true. The interaction is disbled exctley beqouse of the reasons above.

In order to work this you should implement some editing module like cell edit one.

Note that if you do that for local data manipulation you should set explecit which column is a id. For this purpose use key : true property - see docs.

Regards

Tony

Viral Gala on checkbox formatter

Sun, 20 Feb 2011 16:58:35 +0200

I wanted to sort the column having checkbox formatter

I am using checkbox formatter with formatoptions:{disabled :false}

Suppose my grid contain 6 row with three row containing checkbox as checked and other as not checked

If user check fourth checkbox and then sort thean all four rows out of six should be at the start or end of grid

currently if user click on sort then only3 rows with checkbox as checked are displayed

I am using unformat option but the unformat function is not getting called while sorting

I am using jqgrid 7.2 version

Below is the code

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

function myunformatCurrency (cellvalue, options, cellobject )

{

alert(cellvalue);

return cellvalue;

}

jQuery(document).ready(function(){

jQuery("#list").jqGrid({

datatype: "local",

height: 250,

colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes', 'closed'],

colModel:[

{name:'id',index:'id', width:60, sorttype:"int"},

{name:'invdate',index:'invdate', width:90, sorttype:"date"},

{name:'name',index:'name', width:100},

{name:'amount',index:'amount', width:80, align:"right",sorttype:"float"},

{name:'tax',index:'tax', width:80, align:"right",sorttype:"float"},

{name:'total',index:'total', width:80,align:"right",sorttype:"float"},

{name:'note',index:'note', width:150, sortable:false},

{name:'closed',index:'closed',width:55,align:'center', editable :true, formatter:'checkbox',formatoptions:{disabled :false}, unformat:myunformatCurrency,sortable: true,sorttype:"number" }

caption: "Manipulating Array Data"

});

var colNames = ["id", "invdate", "name", "note", "amount", "tax", "total", "closed"];

var newData = [

[10, "2007-09-01", "test4","new data", "600.00", "1.00", "601.00", 0],

[11, "2007-09-02", "test5","new data11", "602.00", "1.00", "603.00", 1],

[12, "2007-09-02", "test5","new data11", "602.00", "1.00", "603.00", 0],

[13, "2007-09-02", "test5","new data11", "602.00", "1.00", "603.00", 1],

[14, "2007-09-02", "test5","new data11", "602.00", "1.00", "603.00",0],

[15, "2007-09-02", "test5","new data11", "602.00", "1.00", "603.00", 1]

];

for(r = 0; r < newData.length; r++)

{

for(c = 0; c <= colNames.length; c++)

{

oper = c == 0 ? 'addRowData' : 'setRowData';

jQuery("#list").jqGrid(oper,r ,eval("({" + colNames[c]+":"" + newData[r][c] + ""})"));

}

});

</script>

</head>

<body>

</body>

</html>

Please help

Thanks,

Viral Gala

jQuery Grid Plugin - jqGrid - Topic: checkbox formatter

tony on checkbox formatter

Viral Gala on checkbox formatter