Bug 160505

from cmt#13 of see also bug 36449, prompting opening of this enhancement request:

Petros Christopoulos 2024-04-03 13:38:06 UTC
I stumbled upon this issue while trying to migrate to LibreOffice and would like to restate the problem:
the request primarily concerns a Back button that would send you back to the previous position after clicking on a hyperlink (=position of the previously clicked hyperlink) with one click. There is no other way to achieve this: for example the Navigator would offer you a long list of names, images etc in the entire document, but no way to easily find and directly select the last element you had your cursor on before the clicking the last hyperlink (if there happens to be any at all).
Since Writer already has such a feature, it should be relatively easy to implement in Calc as well.
Since Calc also has hyperlinks like Writer, why have Back/Forward buttons only in Writer and not also in Calc?

A couple of additions for the sake of better clarity:
1. This is not about springing among different files. A Calc hyperlink can also be used to open another file (Calc or other), but the button I am referring to would just get you back to the last hyperlink in the same Calc file
2. Actually the only important button is the Back button. Instead ot the forward button, you can just click on the hyperlink again to move forward again.
3. This does no need to get you back to the last modified position of the Calc document (as mentioned in some other post above, which would be more complicated to implement) -> the requested behaviour is just to get back to the last hyperlink that was clicked. This should be much easier to realize.

*** Bug 160504 has been marked as a duplicate of this bug. ***

Unlike Writer where movements between pages are large and rare, Calc involves rather many short positional changes. For example, you jump from heading 1 on page 1 to heading 2 on page 4. Versus Sheet1.$A$1 to Sheet2.$A$1.
It also means to completely change the Navigator header that needs to show and navigate either between sheets or ranges or other types.

On the other hand it might be an improvement for things like bug 159432 "Sort and/or filter Named Ranges And Expressions from Manager" and IIRC there was a request to search the sheet names. Meaning documents with a large number of sheets.

(In reply to Heiko Tietze from comment #3)
> Unlike Writer where movements between pages are large and rare, Calc
> involves rather many short positional changes. For example, you jump from
> heading 1 on page 1 to heading 2 on page 4. Versus Sheet1.$A$1 to
> Sheet2.$A$1.
> It also means to completely change the Navigator header that needs to show
> and navigate either between sheets or ranges or other types.
> 
> On the other hand it might be an improvement for things like bug 159432
> "Sort and/or filter Named Ranges And Expressions from Manager" and IIRC
> there was a request to search the sheet names. Meaning documents with a
> large number of sheets.

Right, and why a stack based "recency" means to track movement across a cells and sheets of a spreadsheet seems appealing. Would require new navigation shell within sc, but the UI and TB should be reusable?

We discussed the topic in the design meeting.

To summarize the discussion:
+ it makes no sense to track movements per cell
+ a use case limited to named ranges, objects, etc. is feasible but unclear
+ however, there would be no harm in having such a feature

Thank you, is there a rough prognosis regarding potential implementation?