Categories | Question details Back To List | ||
follow up again on adding row with different row types 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? Answer posted by Support on Dec 20, 2007 02:47 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. |