+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: how to insert row / column in spreadsheet (/thread-1992.html)
how to insert row / column in spreadsheet - 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
RE: how to insert row / column in spreadsheet - Michael de Estrada - 08-19-2014 12:57 PM
(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.
RE: how to insert row / column in spreadsheet - Thomas_Sch - 08-19-2014 05:10 PM
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 ..?