Hi Martin
In the GUI, you can select some cells in calc, press DEL and then choose
"delete all" to remove everything from the selected cells.
How is this done using the API? I want to give a column and delete the
content of this completely without removing the whole column.
Okay, I could get the used area, iterate over all the cells in the
CellRange, query a XTextRange and use setString to empty the cell, but isn't
there a more efficient way?
The CellRange supports an Interface called "XSheetOperation" which has a
method clearContents() ... with the right flags as parameter this should
do what you want.
Hope that helps
Regards
Stephan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
