HP Forums

Full Version: Spreadsheet: insert/delete rows/columns?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is there some way to insert or delete rows or columns in the spreadsheet? I haven't been able to figure it out by experimentation, nor have I found any reference to this in the manual, or with a quick forum search.
It seems that no.

Sorry , I still have not had time to work on this Sad

Excellent remark! It would be great to have such functionality. One could program a kind of DB using the spreadsheet app. I would also suggest a sort and a search function (returning the cell coordinates where data is found) that we can use from a program to read the content of that cell.
Having it available as a programmable operation would be even more handy. But it's one of those things I consider to be part of bare-minimum functionality for a useful spreadsheet.

I'll have to stick to my Casio for doing small spreadsheets for the time being. ;D (The Casio spreadsheet has its own share of limitations, of course, but they can frequently be worked around with clever layout...)
You're right, I can't insert/delete rows/spreadsheets either. Not even on the latest firmware.
I would propose something like:
Rinsert(Row,v1,v2,v3,v4...) if Row exists it will be replaced, to add at the end, Row=0
Cinsert(Col,v1,v2,v3,v4...) if Col exists it will be replaced, to add at the end, Col=0
Rdelete(Row,[0,1]) where 0=without rest rows shift, 1=with rest rows shift
Cdelete(Col,[0,1]) where 0=without rest cols shift, 1=with rest cols shift
Sort(Col,[0,1]) where 0=Ascendant and 1=Descendant
CellSearch(value) to retrun 0 if not found or a table with Rows, Cols of occurrences of the cells containing the value
SSSave(filename) to save the current spreadsheet on the flash memory
SSOpen(filename) to load the saved spreadsheet and replace the existing
SSDelete(filename) to delete a saved spreadsheet from the flash memory

Of course, the naming of the commands is subjective

This would open a new perspectives and indeed push far away the limits of the HP Prime
Reference URL's