[Solved] Clear contents in Calc named cell range

[TheGurkha]

I'm trying to clear a named cell range in a Calc macro.

Code: Select all   Expand viewCollapse view

CellRange = Sheet1.getCellRangeByName("F15:F26") 'The Tick Boxes
Flags = 23
CellRange.clearContents(Flags)

works correctly. (In the actual code, Flags is defined using the preset com.sun.star values.) But when I define a named cell range

Code: Select all   Expand viewCollapse view

CellRange = ThisComponent.NamedRanges.getByName("TickBoxes")
Flags = 23
CellRange.clearContents(Flags)

returns an error 'method not found: clearContents'. The cell range appears to be understood by Navigator.
What am I doing wrong here?

[JohnSUN-Pensioner]

Try this
CellRange = ThisComponent.NamedRanges.getByName("TickBoxes").getReferredCells()

[Villeroy]

NamedRange should be called NamedExpression. It is not a range. It is the item you see in the named range dialog.
It has a name, a formula expression as content, a base address for relative references (in the GUI that is the active cell) and it has a set of flags (below the More button in the GUI).
http://www.openoffice.org/api/docs/comm ... Range.html

If and only if the name refers to a absolutely absolute address, method getReferredCells returns a com.sun.star.table.XCellRange

The following Basi code has been recorded by the MRI tool:

Code: Select all   Expand viewCollapse view

Sub Snippet(Optional oInitialTarget As Object)
  Dim oNamedRanges As Object
  Dim oObj_1 As Object
  Dim sContent As String
  Dim oReferredCells As Object

  oNamedRanges = oInitialTarget.NamedRanges
  oObj_1 = oNamedRanges.getByName("MyRange")
  sContent = oObj_1.getContent()
 
  oReferredCells = oObj_1.getReferredCells()
  oReferredCells.clearContents(23)
End Sub

oInitialTarget is the same as ThisComponent
String sContent is "$Sheet1.$B$3:$E$16" which is an absolutely absolute range address with 5 $-signs so it is possible to get the referred cells.

[kingfisher]

Off topic, an aside.

The following Basi code has been recorded by the MRI tool.

I've searched for an answer to this question, perhaps someone would indulge me and tell me how to record using MRI.

[Villeroy]

OK, you can not record any actions in the office GUI, but your actions in the MRI tool gets recorded. When you move the mouse pointer near the bottom of the MRI window you may notice that it turns into a vertical double arrow. Drag the bottom border up and you'll see a sub-window with the recorded snippet. In the menu you can switch between Basic, Python, Java and others.

[pansmanse]

Thanks Villeroy and John-SUN-Pensioner. That's useful and very clear. (and solved the issue)

[JohnSUN-Pensioner]

Alternatively, you can open sub-window by double-clicking on this line. You can open this subwindow by double right-click on the bottom right gray square.
New Year's surprise ...
Happy New Year!

[kingfisher]

Thank you Villeroy and JohnSUN.