Bug 91566 - add different access to list of sheets
Summary: add different access to list of sheets
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Sheet
  Show dependency treegraph
Reported: 2015-05-24 07:07 UTC by Edmund Laugasson
Modified: 2022-06-22 05:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

an example how could be the the sheets grouping solved (42.03 KB, image/png)
2015-05-24 07:07 UTC, Edmund Laugasson
Sheet list view in Onlyoffice (12.65 KB, image/png)
2022-06-22 05:53 UTC, Jaise James

Note You need to log in before you can comment on or make changes to this bug.
Description Edmund Laugasson 2015-05-24 07:07:45 UTC
Created attachment 115947 [details]
an example how could be the the sheets grouping solved

Using 64-bit Linux Mint Cinnamon 17.1 with 4.0.4-040004-generic kernel
LibreOffice version:
Build ID: 0a16c3dda4150008d9be6f24cbd15ac198d116d3
Locale: et-EE (et_EE.UTF-8)

The idea comes from Google Spreadsheet where it will automatically group sheets regardless how many them there are - see the attachment.

It would be useful in two cases:
* if there are many sheets
* if the sheet names are a bit longer than possible to see

In attached picture there is shown how it can be solved in Google Spreadsheet.
Comment 1 Edmund Laugasson 2015-05-24 07:10:31 UTC
The idea is to group sheet names into push up menu list so it would be easier to choose - especially when in touch screen but not only. It is always much more easier to choose the sheet name from list than scroll it, especially when there are a lot of sheets and possibly some are with long names.
Comment 2 Edmund Laugasson 2015-05-24 07:20:19 UTC
I know that it is implemented by Navigator but for backward compatibility with Google Spreadsheet it would be very useful. Especially in case of beginners who do not know nothing about Navigator.
Comment 3 Cor Nouws 2015-05-24 07:36:14 UTC
thanks for the idea Edmund.
Set to new.

Mind: interference with current context menu needs to be done properly.
Comment 4 Tomaz Vajngerl 2015-05-24 07:39:44 UTC
There is a list of tabs when you right-click on < > buttons, But yes, there is no dedicated button for the list.
Comment 5 Cor Nouws 2015-05-24 07:55:39 UTC
Ah, thanks Tomaz,

Did you revert the summary to "FEATURE REQUEST: group the sheets"
I do not see how that should be clear :)

And did you reset to unconfirmed? Or is BugZilla going weird?
Comment 6 Mamoth 2015-10-30 14:45:14 UTC

I second the suggested feature, but would like to suggest a different alternative:

To offer the possibility to visually group the tabs of several sheets together.

Indeed, I sometimes work of Calc files with many sheets (up to > 30) and navigation from one sheet to another is annoying. These sheets can often be grouped functionally (i.e.: out of the 30 sheets, there are 12 of them that belong to the same topic #1, and then 8 to the topic #2, 5 to topic #3, and so forth).

I would then be useful to be able to to group  several sheets together in one single tab but with a drop-down list : one click on the tab opens the drop-down list and lets the user choose from the available sheets, a second click on the tab closes the drop-down list.

This could also be an add-on to LO.
Comment 7 Jaise James 2022-06-22 05:53:29 UTC
Created attachment 180886 [details]
Sheet list view in Onlyoffice

Sheet list view in Libreoffice is very good feature.