How to set cell value?

Hi,

I tried set value on a cell in a row (using setCellValue), but failed.

obj.onCellValidated = function(text, column, row){
var nCol=0;
var nRow=0;

var x;
for(var x=0; x< obj.getRowCount(); x++) {
nCol = nCol + obj.getCellValue(column, x);
}

for(var x=4; x< 15; x++) {
nRow = nRow + obj.getCellValue(x, row);
}
obj.setCellValue(4, row, nRow);
//obj.refresh();

alert(nCol);
alert(nRow);
}

Help please. :)

any help?

In 2.0.0 during the cell editing all cell updates are blocked. This is a bug, the intention was to block only updates to the _current_ cell. It will be fixed in 2.0.1.

Currently you may try updating cells in onCellEditEnded event which fires after the edit is completed.