HP Forums

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

(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.

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 ..?