Using the following lines in my Calc macro:
oRange = ThisComponent.Sheets.getByName("MySheet").getCellRangeByName("I21:AC47")
oRange.clearContents(1)
It also clears the Conditional formatting, why ?
clearContents(1) should only remove a VALUE right ?