Spreadsheet delete row or column externally? - Printable Version +- HP Forums (https://www.hpmuseum.org/forum) +-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html) +--- Forum: HP Prime (/forum-5.html) +--- Thread: Spreadsheet delete row or column externally? (/thread-4814.html)

Spreadsheet delete row or column externally? - DrD - 09-27-2015 10:53 AM 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- RE: Spreadsheet delete row or column externally? - cyrille de brébisson - 09-28-2015 05:35 AM 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 RE: Spreadsheet delete row or column externally? - Eddie W. Shore - 09-29-2015 01:17 PM This is a good thing to put on the to do list for the next update.