How can I jump to a referenced cell?

[ChameleonScales]

@Lupp

If you don’t want to leave the edit mode of the formula. you surely can’t “jump” to a referenced cell or range

you can do it for the first reference by using Ctrl+[ (although it’s probably an unintended use of the feature because it replaces your text selection by the reference, so if you select the second one and press the shortcut, it will be replaced by the first one.

Most what you probably need to do, is showing the respective sheet

Yes but I have sheets that may have about 1000 columns with cells that already have background and border colors, so the colored borders in edit mode is of little help. Checking the name and finding the cell can get time-consuming and distracting from the task at hand. But anyway, there’s no alternative right now.

Thanks for your help though.

[EarnestAl]

Trace Precedents might be clearer. Possibly split window or second window might help

[mikekaganski]

@EarnestAl

Trace Precedents might be clearer

… and would be the correct direct answer to the original question (the feature is designed specifically to provide visual indication, and to allow navigating easily, to the linked cells) - if not for tdf#63087.

@NewbieNewb

let’s say I’m at Sheet1 cell A1. This cell takes the value of Sheet2, cell B2

That bug disallows navigating to other sheets yet

[ChameleonScales]

The blue arrows of Trace Precedents are not helping if they are superimposed due to pointing in the same direction. The only full-proof solution (that does not exist in LO) would be either a right-clic context menu in edit mode with a “Shift view to selected reference”, or a keyboard shortcut that does the same.

[mikekaganski]

@ChameleonScales

The blue arrows of Trace Precedents are not helping if …

Any issues need their own feature requests / bug reports. “There’s a solution, though it has issues, and I have a vision for something shiny and perfect” is different from “there is no solution / that is not a solution”. The only real issue here, deducible from OP’s question (and not from others’ “I know a scenario where it would also be imperfect”), is the problem with pointing to different sheets.

[Villeroy]

I suggest the attached extension as a provisional solution. I’m still not sure if I handle all eventualities correctly.
The extension installs a Basic library “GoToPrecedents” without user interface elements. You may customize the context menu of spreadsheet cells adding the macro GoToPrecedents.Module1.Goto_Direct_Precedents. It works just fine from the context menu. You may also add a custom shortcut, menu entry or toolbar button calling the same macro.

The macro shows a little dialog in the upper-left corner of the document window.
A label shows the address of the active cell.
A list box shows addresses referenced by the active cell.
When you click a reference in the list box, the referenced range will be selected.
When you cancel the dialog, the original selection will be restored.
When you confirm the dialog, the selection remains where it is.
All addresses are shown in a simple notation without $. They all refer relatively or absolutely to the active cell.
I’ve tested several types of cell references:

• A1 or A1:B5 on the same sheet as the active cell will be displayed without sheet name.
• Named expressions (aka “named ranges”) are resolved recursively to the referenced addresses. Recursively means, that if “XRow” refers to $Sheet1.$D$16:$H$16, “XCol” refers to $Sheet1.$F$13:$F$21 and “XIntersect” refers to XRow!XCol, “XIntersect” will be resolved into the two address strings Sheet1.D16:H16 and Sheet1.F13:F21.
  Relative references in named expressions are resolved relatively to the active cell.
• External links like file:///Path/Doc.ods#Sheet1.A1:X99are supported. When you click an external link, an additional hyperlink appears below the list box where you can open the linked document.
• Label references (menu:Sheet>Named Ranges>Labels…) are resolved into the matching label cell.
• An error cell will show all its references.
• Cells showing the #REF! error display all intact references and the broken ones.
  #REF!.A999 indicates that the referenced sheet has been deleted.
  Sheet1.#REF!999 indicates that the column has been deleted.
  Sheet1.A#REF! indicates that the row has been deleted.
  Clicking a broken ref does not change the selection.
• Array formulas are supported.

Here it is: myTUXEDO (2nd version)

Screenshot with external link selected and hyperlink.