Spreadsheet: insert/delete rows/columns?
|
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 »
|
Messages In This Thread |
Spreadsheet: insert/delete rows/columns? - Dave Britten - 07-30-2018, 04:29 PM
RE: Spreadsheet: insert/delete rows/columns? - Voldemar - 07-30-2018, 08:57 PM
RE: Spreadsheet: insert/delete rows/columns? - cyrille de brébisson - 07-31-2018, 05:22 AM
RE: Spreadsheet: insert/delete rows/columns? - scorpio72 - 08-01-2018, 09:07 AM
RE: Spreadsheet: insert/delete rows/columns? - Dave Britten - 08-01-2018, 11:12 AM
RE: Spreadsheet: insert/delete rows/columns? - Eddie W. Shore - 08-05-2018, 01:26 AM
RE: Spreadsheet: insert/delete rows/columns? - scorpio72 - 08-05-2018 07:35 AM
|
User(s) browsing this thread: 1 Guest(s)