Threaded Mode | Linear Mode

resolved · 08-19-2014, 08:39 AM

is it possible to insert a new row or column inside the spreadsheet??? I could not find anything about this in the 616 page manual

Michael de Estrada · (This post was last modified: 08-19-2014 12:57 PM by Michael de Estrada.)

(08-19-2014 08:39 AM)resolved Wrote: is it possible to insert a new row or column inside the spreadsheet??? I could not find anything about this in the 616 page manual

Nope. It's one the many silly omitted capabilities of this otherwise very useful app. You also can't delete a row/column directly. The only choice is to select all the cells below the row or to the right of the column you wish to insert, and cut/paste them either down or right one row/column. It's very cumbersome but doable. Sad

Thomas_Sch · (This post was last modified: 08-19-2014 05:14 PM by Thomas_Sch.)

Maybe inserting a row/column can be down with instructions in the commandline like
A2:X991 := A1:X990 or
B1:Y990 := A1:A990 ?
(copying all data one row/coumn to the right / to down und using the "free" row/column).

My attempts to do so were only partially successful.
Some cells were filled with lists/matrices representing columns ..?