Post Reply 
Spreadsheet: insert/delete rows/columns?
07-30-2018, 04:29 PM
Post: #1
Spreadsheet: insert/delete rows/columns?
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.
Visit this user's website Find all posts by this user
Quote this message in a reply
07-30-2018, 08:57 PM
Post: #2
RE: Spreadsheet: insert/delete rows/columns?
It seems that no.
Find all posts by this user
Quote this message in a reply
07-31-2018, 05:22 AM
Post: #3
RE: Spreadsheet: insert/delete rows/columns?
Hello,

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

cyrille

Although I work for the HP calculator group, the views and opinions I post here are my own. I do not speak for HP.
Find all posts by this user
Quote this message in a reply
08-01-2018, 09:07 AM
Post: #4
RE: Spreadsheet: insert/delete rows/columns?
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.
Find all posts by this user
Quote this message in a reply
08-01-2018, 11:12 AM
Post: #5
RE: Spreadsheet: insert/delete rows/columns?
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...)
Visit this user's website Find all posts by this user
Quote this message in a reply
08-05-2018, 01:26 AM
Post: #6
RE: Spreadsheet: insert/delete rows/columns?
You're right, I can't insert/delete rows/spreadsheets either. Not even on the latest firmware.
Visit this user's website Find all posts by this user
Quote this message in a reply
08-05-2018, 07:35 AM
Post: #7
RE: Spreadsheet: insert/delete rows/columns?
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
Cell(Row,Col,Value):=x
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
Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: