Ask Your Question
1

group and outline level button

asked 2018-05-01 22:51:48 +0100

alavarre gravatar image

I have an outline with buttons for levels 1-8. (LibreOffice 6 Calc).

I can click a button to hide details of all lower levels.

How can I click the button with a macro? I tried Hide, but that doesn't collapse the outline.

Where is the API for dispatcher.executeDispatch(document, ".uno:HideDetail", "", 0, Array())

TIA, Andy

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-05-02 15:43:53 +0100

Jim K gravatar image

The interface is com.sun.star.sheet.XSheetOutline. Here is example code.

Sub HideDetail
    oSheet = ThisComponent.getSheets().getByIndex(0)
    iStartRow = 1
    iEndRow = 5
    oCellRange = oSheet.getCellRangeByPosition(0, iStartRow, 0, iEndRow)
    oSheet.hideDetail(oCellRange.getRangeAddress())
End Sub
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-01 22:51:48 +0100

Seen: 98 times

Last updated: May 02 '18