sir, you suggested me to use setColExcelTypes and setRowExcelTypes in changing the type of rows and cells on the fly. However, I am only using a trial version. Are there any alternatives for it?
The next will work simlar to setRowExcelTypes, and can be applied in standard version
mygrid.forEachCell(ID,function(ed){
var t=ed.getValue();
ed.cell._cellType=TYPE;
ed.setValue(t);
});
where ID - ID of row
TYPE - excell type
setting _cellType property change type of editor, two other lines reset value of cell, so it will be correctly formatted.