[Solved] Grumble, Grumble. Can't Hide Sheets.

daveg7 · Post by **daveg7** » Mon Oct 23, 2017 12:56 pm

Just for discussion, and not necessarily trying to solve anything, I can't find on the menu of tabs on the bottom how to hide sheets.

Inconvenient, to say the least.

edit this topic's initial post · Post by **Villeroy** » Mon Oct 23, 2017 1:14 pm

LibreOffice provides a context menu entry for this.
In AOO:
F1
[Index]
hid

daveg7 · Post by **daveg7** » Mon Oct 23, 2017 1:29 pm

Oops! So obvious!

Thanks!

Post by **RoryOF** » Mon Oct 23, 2017 2:43 pm

In OpenOffice, select sheet, then /Format /Sheet /Hide; ~~this may also work on LibreOffice (untested)~~.

Edit: Does not work on LibreOffice - see Lupp's posting (next in thread)

Lupp · Post by **Lupp** » Mon Oct 23, 2017 3:44 pm

RoryOF wrote:...this may also work on LibreOffice (untested).

Not quite. In recent versions of LibO Calc there is no longer access to commands concerning hiding or showing sheets via the main menu item 'Format'.
Calc now has a main menu item 'Sheet' where many single commands and aslo submenus are collected. There you find 'Hide' and 'Show' if applicable.
A similar access is offered (as already mentioned) by the context menu of sheet tabs.

In addition there is the ribbonesque 'Toolbar Layout' 'Notebookbar' (aka "Muffin") for some time now in LibO. It doesn't seem many users prefer it to date. Otherwise I am afraid we will have to multiply our answers if the handling is concerned.

Post by **RoryOF** » Mon Oct 23, 2017 3:49 pm

Thanks, Lupp. I don't use LibreOffice so am not familiar with any changes.

[Solved] Grumble, Grumble. Can't Hide Sheets.

[Solved] Grumble, Grumble. Can't Hide Sheets.

Re: Grumble, Grumble. Can't Hide Sheets.

Re: Grumble, Grumble. Can't Hide Sheets.

Re: [Solved] Grumble, Grumble. Can't Hide Sheets.

Re: [Solved] Grumble, Grumble. Can't Hide Sheets.

Re: [Solved] Grumble, Grumble. Can't Hide Sheets.