Bug 119553 - A better navigation in Calc's tabs
Summary: A better navigation in Calc's tabs
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-28 02:02 UTC by J22Gim
Modified: 2018-09-02 01:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
This is what I imagine can be done with tabs (Sheets) in a spreadsheet. See right side of the picture. The mouse is pressed over a downward arrow. (158.93 KB, image/jpeg)
2018-08-28 02:04 UTC, J22Gim
Details
right click (44.82 KB, image/png)
2018-08-28 06:37 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description J22Gim 2018-08-28 02:02:18 UTC
Description:
I suggest an improvement for Calc: a better (faster and more intuitive) way of navigate through tabs in a spreadsheet. Very useful when working with many tabs.



Steps to Reproduce:
1. Create a new file
2. Create many new sheets (AKA tabs), for example 70 new sheets

Actual Results:
What do you do if you want to move from Sheet1 to Sheet50? 
Answer: You have to "search" for it it sequentially, ie go from Sheet2 to Sheet50 either by repeatedly pressing the right-pointing arrow or quickly scrolling with the mouse (and probably missing all the names in between). Or you can go directly to Sheet70 (ie using the "'go to last'-arrow" button) and then "come back" with the left arrow until you find Sheet50. That is suboptimal (considering there are tools available to avoid this) and somehow too "mechanical" GUI behavior.

Expected Results:
I suggest adding a 5th arrow, pointing either up- or downwards, which shows a drop-down menu of all the tabs. I borrowed the idea from Firefox*, please see attached example. This shows in bold font the tab currently in display, and all the other tabs in regular fonts. This is very nice because let's you see at a glance all the tabs with their names, their order and also move very quickly to the one you need to go. This non-linear movement from one tab to another is much more appealing, in my opinion, than the traditional way of sequentially looking for one tab, which makes sense probably only in the 80's when Lotus was developed and early 90's. Anyway, I think it would be a very nice addition for average and new users because it's, in my view, much more "natural" than pressing 50 times a button to scroll 50 tabs.

* Honestly I can't remember if it is the default behavior or I have a plugin for this.


Reproducible: Always


User Profile Reset: No



Additional Info:
I don't know if MS Excel has this, but it would be a nice addition to add a useful tool that other spreadsheet packages don't have...

Version: 6.0.1.1
Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: kde4; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 1 J22Gim 2018-08-28 02:04:41 UTC
Created attachment 144492 [details]
This is what I imagine can be done with tabs (Sheets) in a spreadsheet. See right side of the picture. The mouse is pressed over a downward arrow.
Comment 2 raal 2018-08-28 06:37:35 UTC
Created attachment 144493 [details]
right click

Hello, use right click to get list of sheets.
Comment 3 J22Gim 2018-09-02 01:52:13 UTC
Nice! I didn't know!
Not very intuitive though... I can't think of any app where the user would right-click on a plus sign...