HP Forums

Full Version: Spreadsheet delete row or column externally?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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-
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
This is a good thing to put on the to do list for the next update.
Reference URL's