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:
we don't have fast method to jump to sheet if we have many sheets
we have fast method to jump to sheet if we have many sheets
User Profile Reset: No
follow from https://ask.libreoffice.org/en/question/222890/can-i-jump-to-a-specific-worksheet-via-keyboard-shortcuts/
Created attachment 156820 [details]
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
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.
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!)
(In reply to jackandmixers from comment #4)
> Hey, new guy to UX here!
> ... 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.