Bug 98410 - Allow grouping of sheets tabs
Summary: Allow grouping of sheets tabs
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet-Tabs-Bar
  Show dependency treegraph
 
Reported: 2016-03-04 12:27 UTC by Mamoth
Modified: 2024-02-27 12:53 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot of sheet list (30.24 KB, image/jpeg)
2016-03-04 13:57 UTC, GerardF
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mamoth 2016-03-04 12:27:35 UTC
Hello.

This is feature suggestion for LO Calc.

Quite often, spreadsheet files end up having many, many sheets. I often use spreadsheet files with over 10 sheets, sometimes over 30.

Using the current tab system , changing the active sheet from the left-most one to the right-most one and vice-versa is quite annoying in these cases.

There are two improvements I can think of to ease the navigation between the different sheets :

 - Do as Google Spreadsheets does : add in the left-bottom corner a drop-down menu (actually a drop-up menu) with the list of all the tabs.
 - Alternatively and possibly more interestingly, use grouped tabs : i.e. let the users be able to group sheets together according to their will with one visible tab for each sheets group. When the user click on the tab for one sheets group, a drop-up menu with the list of sheets inside this group appears so the user can choose from it the sheet they want to activate.
Comment 1 GerardF 2016-03-04 13:57:47 UTC
Created attachment 123229 [details]
screenshot of sheet list

Your 1st proposal is already there. See attached screenshot.
Right-click on sheet navigation button display a list with the sheets.
Comment 2 Cor Nouws 2016-03-04 14:29:51 UTC
Thanks for reporting Mamoth.
I set this a a new enhancement.
Cor
Comment 3 Mamoth 2016-03-05 09:56:05 UTC
Hi.

First, thanks for pointing me to the fact that the first variant of the proposed enhancement is already available. I did not know.

There still is the second variant, which I believe would be a gain in user-friendliness for the software.

Keep up the good work, lads !
Comment 4 othniel 2024-02-27 12:15:35 UTC
is there any update on this? this would be extremely helpful.
Comment 5 ady 2024-02-27 12:53:01 UTC
(In reply to Mamoth from comment #0)

> Using the current tab system , changing the active sheet from the left-most
> one to the right-most one and vice-versa is quite annoying in these cases.

Although groups of worksheet tabs are not yet available, going from the left-most tab to the right-most tab is just one key away since LO 24.2, for example using [CTRL]+[TAB] or [CTRL]+[SHIFT]+[TAB], or with [CTRL]+[PgDn] or  [CTRL]+[PgUp].