Download it now!
Bug 129674 - Add "Goto sheet" dialog to Calc
Summary: Add "Goto sheet" dialog to Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: Calc-UX
  Show dependency treegraph
Reported: 2019-12-28 20:43 UTC by Roman Kuznetsov
Modified: 2020-04-27 21:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Mockup (17.74 KB, image/png)
2019-12-28 20:43 UTC, Roman Kuznetsov

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2019-12-28 20:43:09 UTC
Add "Goto to sheet" dialog to Calc like "Goto to page" in Writer.

If we have many sheets in spreadsheet and/or sheets have very long names then would be useful to have "Goto to sheet" dialog and shortcut Ctrl+G for it.
The dialog should have find field and list of sheet names.
Find field should have a focus by default.
You'll can select any sheet using a mouse or a keyboard.

A mockup is in attach.

Steps to Reproduce:

Actual Results:
we don't have fast method to jump to sheet if we have many sheets

Expected Results:
we have fast method to jump to sheet if we have many sheets

Reproducible: Always

User Profile Reset: No

Additional Info:
follow from
Comment 1 Roman Kuznetsov 2019-12-28 20:43:33 UTC
Created attachment 156820 [details]
Comment 2 Xavier Van Wijmeersch 2019-12-29 11:20:58 UTC
First i thought its a ok but after reading the question on the given link 'ask libreoffice' and the answers i read there am not for this.
I tested with a spreadsheet with 10 sheet and the proposed item is more a click and point solution.
Most heavy workbooks have a first sheet with all name's on it.
Then "just type the sheetname into the range field (name box) of the formula bar leftmost. An info box "Go To Sheet" will appear and just press" its very fast.
But this is only my own opinion. -1

Best regards
Comment 3 Heiko Tietze 2020-01-06 16:36:15 UTC
How about >100 sheets? Sounds like a bad approach to me as well. But why should we limit the user? 

So +1 from my side, but -1 to the shortcut. Ctrl+G is assigned to "repeat search". Furthermore, the newly introduced function would be needed by only a few users and we must not spend precious shortcuts for it.
Comment 4 jackandmixers 2020-01-22 01:43:01 UTC
Hey, new guy to UX here!

What about adding another button to this search feature instead of replacing it? So for example the hotkeys could be Shift+Ctrl+G instead of having to swap around the interface.

Alternatively, as I am unfamiliar with some of the technology, what about adopting a page out of video editor's books and create customizable hotkeys? Then the user could map their shortcuts to whatever buttons they want.

(Again, I'm a total newbie to UX design, so I hope this doesn't prove unhelpful. Thanks!)
Comment 5 Heiko Tietze 2020-01-22 09:14:52 UTC
(In reply to jackandmixers from comment #4)
> Hey, new guy to UX here!

Welcome aboard!

> ... create customizable hotkeys?

If the function is execute per UNO command, no reason not to use this technology, it will become part of tools > customization and therefore can be manually assigned to a shortcut. 

Everything we implement as default is very hard to remove later. That is the UNO command itself and the shortcuts too.