Post Reply 
Spreadsheet delete row or column externally?
09-27-2015, 10:53 AM
Post: #1
Spreadsheet delete row or column externally?
Is there a convenient way to delete spreadsheet rows (or columns) from within a program?
I have a program-created spreadsheet, populated with several rows and columns, in which cell based operations left some rows empty. I can easily detect the blank rows, but simply deleting the blank rows would be far better than moving data around.

Thanks,

-Dale-
Find all posts by this user
Quote this message in a reply
09-28-2015, 05:35 AM
Post: #2
RE: Spreadsheet delete row or column externally?
Hello,

Not at this point, sorry...
You can HIDE the row/column by setting their size to 0, but that is about it.
You can also move the data (as you said), but formulas will not be recalculated if references move.

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
09-29-2015, 01:17 PM
Post: #3
RE: Spreadsheet delete row or column externally?
This is a good thing to put on the to do list for the next update.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)