cellEdit

boolean

Enables (disables) cell editing. When this option is set to true, onSelectRow event can not be used, and hovering is disabled (when mouseover on the rows).

false

cellsubmit

string

Determines where the contents of the cell are saved - can have two values: 'remote' or 'clientArray'.
If remote the content is immediately saved to the server using the cellurl property, via ajax. The rowid and the cell content are added to the url as name:value pairs. For example, if we save the cell named mycell,{id: rowid, mycell: cellvalue} is added to the url.
If 'clientArray', no ajax request is made and the content of the changed cell can be obtained via the method getChangedCells

remote

cellurl

string

the url where the cell is to be saved

null

ajaxCellOptions

array

This option allow to set global ajax settings for the cell editiing when we save the data to the server. Note that with this option is possible to overwrite all current ajax setting in the save request including the complete event.

empty array

afterEditCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event fires after the edited cell is edited - i.e. after the element is inserted into the DOM

afterSaveCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event fires after the cell has been successfully saved. This is the ideal place to change other content.

afterSubmitCell

serverresponse, rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event Fires after the cell and other data is posted to the server Should return array of type [success(boolean),message] when return [true,””] all is ok and the cellcontent is saved [false,”Error message”] then a dialog appears with the “Error message” and the cell content is not saved. servereresponse is the response from the server. To use this we should use serverresponse.responseText to obtain the text message from the server.

beforeEditCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event fires before editing the cell.

beforeSaveCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event fires before validation of values if any. This event can return the new value which value can replace the edited one
beforeSaveCell : function(rowid,celname,value,iRow,iCol) {
if( some_condition )
{ return “new value”; }
}
The value will be replaced with “new value”

beforeSubmitCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event fires before submit the cell content to the server (valid only if cellsubmit : 'remote'). Can return new array that will be posted to the server.
beforeSubmitCell : function(rowid,celname,value,iRow,iCol) {
if( some_condition ) {
return {name1:value1,name2:value2}
}
else
{ return {} }
}
The returned array will be added to the cellurl posted data.

errorCell

serverresponse, status

fires if there is a server error; servereresponse is the response from the server. To use this we should apply serverresponse.responseText to obtain the text message from the server. status is the status of the error. If not set a modal dialog apper.

formatCell

rowid, cellname, value, iRow, iCol

applies only to a cell that is editable; this event allows formatting the cell content before editing, and returns the formatted value

onSelectCell

rowid, celname, value, iRow, iCol

applies only to cells that are not editable; fires after the cell is selected

serializeCellData

postdata

If set this event can serialize the data passed to the ajax request when we save a cell. The function should return the serialized data. This event can be used when a custom data should be passed to the server - e.g - JSON string, XML string and etc. To this event is passed the data which will be posted to the server