Niklas Nebel schrieb:
Volker Lenhardt wrote:

What is the way to delete the contents of a sheet cell? I combed the api
index, I tried Google, I used the macro recorder (...uno:Delete...), but
I find that I am too blind to see the direct way. Where in the api doc
can I find "uno:Delete"?


The macro recorder uses the Dispatch API, which is separate from the "normal" UNO API.

I don't want to set the content to 0 or "", I need to empty the cell,
but leave the formats alone.


Use clearContents (from com.sun.star.sheet.XSheetOperation), with a suitable combination of com.sun.star.sheet.CellFlags values.

Niklas


Thank you Niklas, that was it.

Merry Christmas and a happy New Year
Volker

--
Volker Lenhardt


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to