Frequently, I need to check the value of a cell at another location on a large spreadsheet. I either type in the address and press enter, or if I have named a cell near the one that I want, I use the "Managed Names" facility. Sadly, I must remember the address of the cell from which I jumped - and I often forget it! It would be advantageous if there was a "return" facility much like the "Undo" button to get back to where I was originally.
Hi Dean, Don't we already have that :) .. I like the idea. Set to New. Any suggestion for a key or..? Since Ctrl+Shift+F5 puts focus in Name Box, maybe Alt+Shift+F5 ?
(In reply to Cor Nouws from comment #1) > Hi Dean, > > Don't we already have that :) .. > I like the idea. > Set to New. > > Any suggestion for a key or..? > Since Ctrl+Shift+F5 puts focus in Name Box, maybe Alt+Shift+F5 ? Sorry for the delay in replying. Your suggestion above looks fine to me. Thanks for the prompt consideration of "suggestion". Dean
Thanks Dean for confirming. - Different suggestion from UX? - Maybe an easy hack too ?
(In reply to Cor Nouws from comment #3) > - Different suggestion from UX? What do we do in case of more than one jump? I mean do we store all (insert an arbitrary high number) positions and allow to navigate all the way? Sounds like a breadcrumb task, in this case. On the other hand, if users have a function similar to undo in mind the last position is overridden by any operation. I'm afraid it will be rather the first option, which isn't an easy hack. (In reply to Dean from comment #2) > > Any suggestion for a key or..? > > Since Ctrl+Shift+F5 puts focus in Name Box, maybe Alt+Shift+F5 ? Horrible complex shortcuts. How should remember this? (And the hand position is also not comfortable; clicking a button will be more convenient. Users that want to assign a shortcut can do so, with the option to override ctrl+left/right, and will remember it.)
(In reply to Heiko Tietze from comment #4) > (In reply to Cor Nouws from comment #3) > > - Different suggestion from UX? > > What do we do in case of more than one jump? No idea - but for the use case, one jump back seems appropriate. And prolly simpler too.. (we need tech advise anyway). > > > Since Ctrl+Shift+F5 puts focus in Name Box, maybe Alt+Shift+F5 ? > > Horrible complex shortcuts. How should remember this? (And the hand position Never noted that Ctrl+Shft+Fn is quite often used in LibreOffice :) ?? So then Alt in stead of Ctrl is not too weird, and logic in this case. Or maybe a combination with Z.. Both Ctrl+Shift+Z and Ctrl+Y are redo at the moment.
I had not imagined more than one jump back, since the reason for the initial jump was to refer to a value in a previously named cell. It has occurred to me that a reserved name ("RETURN", perhaps) added to the name list when a jump to another named cell was performed might meet the need. It could be instantiated and added to the list when a jump occurred, and once "clicked" to return to the initial cell, it could be removed from the list. I've no idea how complicated this might be to code, but the one click idea suggested above made the suggestion "come to me", so to speak.
(In reply to Dean from comment #6) > I had not imagined more than one jump back, since the reason for the initial > jump was to refer to a value in a previously named cell. Clear, resaonable! > It has occurred to me that a reserved name ("RETURN", perhaps) added to the > name list when a jump to another named cell was performed might meet the > need. It could be instantiated and added to the list when a jump occurred, > and once "clicked" to return to the initial cell, it could be removed from > the list. Thanks for commenting and the idea Dean. I hadn't thought of that. Only key strokes come to my mind spontaneous ;) A reserved name seems OK to me (but it's two clicks :) ) (note, we also have 'manage names' in the list Name Box) Another option would be a small widget right if the Name Box..?
A widget would be fine. Keystrokes work for me as well. It occurred to me after posting my previous comment that "RETURN" would probably NOT be the best choice, if that was the method that you chose. I suspect that anybody doing financial calculations could be interested in some sort of Rate of Return, and might want to abbreviate it to RETURN. Just a thought..
(In reply to Dean from comment #8) > A widget would be fine. Keystrokes work for me as well. A keyboard action would possibly apply for an easy hack. So then split this idea in two issues, may enhance the change that at least that is implemented fast?
I'm quite comfortable with your suggestion. If there is some way that I can help, please let me know, and thanks for your continuing interest and assistance.
Please add keyword 'needsUXEval' and CC 'libreoffice-ux-advise@lists.freedesktop.org' if input from UX is needed.