[qtipaddictParticipant]

Thanks Peter, that worked! Now I want to format the values in the grid so that 39.404066147905 appears as 39.40. I tried

{ text: 'Latitude', datafield: 'latitude', cellsformat: 'f2' },

but the grid still shows 39.404066147905. I don’t get it.

[qtipaddictParticipant]

Oh no. My link disappeared. There really needs to be a preview button. Here is the JSFiddle link again.

http://jsfiddle.net/ZJJaD/3/

[qtipaddictParticipant]

Okay, I think I figured it out.

var cellEdit = function (row) {
	var rows = $('#jqxgrid').jqxGrid('getboundrows');

	if ( (rows[row]['rule'] == 'Custom') || (rows[row]['rule'] == 'custom') ) {
		return true;
	}
	else {
		return false;
	}
};
		
$("#jqxgrid").jqxGrid(
{
    width: '100%',
    editable : true,
    columns: [
              { text: 'Rule', datafield: 'rule', editable : true, width: 100, columntype: 'textbox'},
              { text: 'A', datafield: 'a', width: 100, columntype: 'numberinput', cellbeginedit: cellEdit },
              { text: 'B', datafield: 'b', width: 100, columntype: 'numberinput', cellbeginedit: cellEdit },
              { text: 'C', datafield: 'c', width: 100, columntype: 'numberinput', cellbeginedit: cellEdit },
              { text: 'D', datafield: 'd', width: 100, columntype: 'numberinput', cellbeginedit: cellEdit }
    ]
});

[qtipaddictParticipant]

I found this, http://www.jqwidgets.com/disable-editing-of-a-grid-row-or-cell/ but I need to enable/disable editing based on the value in another cell.

[qtipaddictParticipant]

Thanks Peter. The “cellvaluechanged” event works a lot better for me. But is there a way to set the editable property for a specific cell? I just realized that my code is enabling editable for the entire column and that is not what I intended.

[qtipaddictParticipant]

If an employee belongs to multiple departments, how would you display that in the grid without hard-coding the mapping (i.e. department>0>id)?

[qtipaddictParticipant]

I used this example http://jsfiddle.net/jqwidgets/XSKXc/ to try to make a column editable on button click but it doesn’t work. Here is the code I tried. What am I missing?

$('#jqxbutton').click(function () {
     $('#jqxgrid').jqxGrid('setcolumnproperty', 'firstname', 'width', 200);
     $('#jqxgrid').jqxGrid('setcolumnproperty', 'firstname', 'editable', true);
 });

[Author]

Posts