How to Delete Row

May 11, 2014 at 1:05 AM
How to Delete Row?
Coordinator
May 11, 2014 at 1:07 AM
Remove from 4, remove 10 rows.
grid.DeleteRows(4, 10);
4 is zero-based number of row. (number of row displayed on spreadsheet is 5)
May 11, 2014 at 8:55 AM
Edited May 11, 2014 at 8:59 AM
thanks first!
Oh sorry i meen
if
grid["A3"]="=A2+B2";

if i delete or insert a row before 2 row,the grid is not change ,
if insert a arow it should be grid["A4"]="=A3+B3"
if delete a arow before 2 row ,it should be grid["A2"]="=A1+B1"
Coordinator
May 11, 2014 at 1:22 PM
Edited May 11, 2014 at 3:25 PM
Thanks for pointing this out. Formula currently will not be regenerated after insert/remove rows or columns, the feature to update references of formula will be available from v0.8.7.