OpenOffice Basic Select All

Question

Does anyone know how to select all the used cells in an OpenOffice Basic Macro? I found this other question telling how to do it with pyUno:

OpenOffice pyuno "select all"

I tried just writing the same code in Basic, but I get an error on the last line:

sheet = ThisComponent.getSheets().getByName(sheetName)
range = sheet.getCellRangeByPosition(0, 0, 0, 0)
range.gotoEndOfUsedArea(True)

The error is Property or method not found, so I guess that means the python method gotoEndOfUsedArea doesn't exist for Basic. Perhaps it is wrapping some other call I can make?

I'm on OpenOffice 3.1.1.

score 3 · Accepted Answer · answered Aug 19 '14 at 14:57

The gotoEndOfUsedArea() belongs to a cursor-object, rather than to a range-object. So you have to do the Basic equivalent to

sheet = ThisComponent.getSheets().getByName(sheetName)
cursor = sheet.createCursor()
cursor.gotoEndOfUsedArea(True)
address = cursor.RangeAddress
endcol = address.EndColumn
endrow = address.EndRow
range = sheet.getCellRangeByPosition(0, 0, endcol, endrow)

I am not familiar with Basic and OpenOffice and so can not provide a solution in Basic, but I hope this python answer does still help.

score 0 · Answer 2 · answered Jul 19 '12 at 21:00

0

Let me guess, you ran this code from the Star Basic IDE when you got that error. This is actually very common. The issue is that when you run your code from the IDE, the "ThisComponent" statement returns a reference to the IDE, NOT to the spreadsheet document. And while a spreadsheet document DOES have a "getSheets" method, the macro development IDE does NOT have such a method. Hence, the error that Star Basic could not find the property or method.

answered Jul 19 '12 at 21:00

Don Briggs

531
2
10
23

I wound up never solving this and just using a different approach. But `getSheets` works fine. Also `getByName(sheetName)` works fine. The problem is that `gotoEndOfUsedArea` doesn't exist on the `range` object. – Paul A Jungwirth Jul 20 '12 at 15:13

score 0 · Answer 3 · answered Jul 07 '11 at 00:31

it's a bit more complicated. sheet.getCellRangeByPosition returns a table::XCellRange whereas the gotoEndOfUsedArea is defined in sheet::XUsedAreaCursor.

But you should be able to cast between the two because they are internally implemented by the same class.

OpenOffice Basic Select All

3 Answers3