Description: Add hamburger menu for quick access to sheets that might remain invisible. Steps to Reproduce: 1. Add many sheets or Work with a book with many pages or long names. Sometimes clicking sheet scroll buttons causes delays. So selecting the target sheet directly from a menu speeds up and optimizes productivity. 2. Click on the burger menu 3. Click on the target sheet Actual Results: Clic in First/Last page and/or scroll through all sheets to target sheet. Expected Results: Optimize productivity and quick access to invisible sheets. Reproducible: Always User Profile Reset: No Additional Info: -
Created attachment 169392 [details] Burger menu for Calc
The same thing is doing the Navigator. Press F5 and go to the sheet you want OR Open the Sidebar and go to Navigator and choose very quick the sheet you want.
This isn't an enhancement request for Base (Database). I changed the Component to Calc.
I like the idea of having a menu of sheets next to the other navigation controls, but I don't agree with it being represented in the UI as a three line "hamburger" icon. In other apps, that icon is reserved for a general purpose main menu. Perhaps an upward or downward pointing triangle would be better. Another option would be to make the Calc document entry in the Window menu into a submenu that shows the individual sheets. If you select the document name it just brings that window to the foreground, if you select an individual sheet, it also displays that sheet.
Adding an icon, or any kind, is not needed. Right-click on the "plus" sign on the left of the worksheet tabs > it shows the list of un-hidden worksheets. I think there was some request to show also the hidden tabs in the list, with some checkbox to allow showing them or some similar method. Showing the hidden items in that list with some different per-line background (e.g. color, outline, shadow...) or some font type / effect / size could also be helpful for some users, even without the checkbox.
We also have the command Sheet > Navigate > Go to Sheet... that could be added to the sheets context menu. But I wonder if Ady's suggestion is sufficient.
It would be helpful if that was available in the help because I was unaware of that menu. In fact, it would be excellent if the help reflected all the things that can be done because it has been lost in time with untranslated texts, options that were moved or eliminated, new options that do not exist ... Anyway.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Leandro Martín Drudi from comment #7) > It would be helpful if that was available in the help... Forwarding to our documentation team to decide. Maybe another solution is a tooltip on the control.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/f412e2dadeeba74aa71293d010d9a6d092d38e64 tdf#140091 Precisions for the (+) button in sheet tabs bar.
(In reply to Heiko Tietze from comment #9) > (In reply to Leandro Martín Drudi from comment #7) > > It would be helpful if that was available in the help... > > Forwarding to our documentation team to decide. Maybe another solution is a > tooltip on the control. I think what you suggest is an excellent solution considering that currently it only says that it is used to add a new sheet. It might say "Add new sheet (right click to see all sheets)"
(In reply to Leandro Martín Drudi from comment #11) > I think what you suggest is an excellent solution considering that currently > it only says that it is used to add a new sheet. See comment 10. > It might say "Add new sheet (right click to see all sheets)" As already mentioned, it is currently not showing _all_ worksheets, but non-hidden worksheets only. There are pros and cons for this behavior.
Heiko Tietze committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/57d5c01ac1bcce56591b4eae96d1e679ef7197d4 Resolves tdf#140091 - Tooltip to add sheets should be more informative It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.