Ask Your Question

How to hide/show Calc sheet tabs from a macro?

asked 2018-09-21 00:58:43 +0200

UserRyan gravatar image

Currently I am able to hide row/column headers, menubar, statusbar, formatting, etc. (basically everything except the cells) from a macro. However, I cannot figure out how to hide the sheet tabs in Calc from a macro without manually doing from Tools->Options->LO Calc->View. Trying to do this from a macro because I would like to toggle it from a keyboard event.

Using LibreOffice 6.1 on Linux

Any help would be greatly appreciated. Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-09-21 01:11:02 +0200

Ratslinger gravatar image


  oCurrentController = ThisComponent.getCurrentController()
REM Hide tabs
  oCurrentController.SheetTabs = False
REM Reveal tabs
  oCurrentController.SheetTabs = True
edit flag offensive delete link more


Can't believe I missed this. Works great, thank you!

UserRyan gravatar imageUserRyan ( 2018-09-21 02:41:36 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-21 00:58:43 +0200

Seen: 63 times

Last updated: Sep 21 '18