Spreadsheet delete row or column externally?

[DrD]

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-

[cyrille de brébisson]

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

[Eddie W. Shore]

This is a good thing to put on the to do list for the next update.