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.
|
|||
07-30-2018, 08:57 PM
Post: #2
|
|||
|
|||
RE: Spreadsheet: insert/delete rows/columns?
It seems that no.
|
|||
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 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. |
|||
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.
|
|||
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...) |
|||
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.
|
|||
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 |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: