Edit: Split from [Solved] Multiple Hyperlinks in one Cell? for new question from new person in solved topic |
In regards to this topic, I would like to ask the question whether it is also possible to reference a target with a relative Hyperlink by using the Hyperlink editor. I am also referencing multiple targets by using the Hyperlink editor in one cell just like guts1999 and I can also confirm that it has been working without problems until so far. However, when the document structure is changed, e.g. by inserting a new column or row and I click on the Hyperlink reference again, it still points to the old target cell. I am aware of the fact that this behavior can be adjusted to behave in a dynamic way according to this forum https://ask.libreoffice.org/t/calc-hype ... tion/42292, nevertheless I did not find an answer on how to do this properly with the Hyperlink editor.
So the question is, how can a target cell in an OpenOffice Calc document be relatively referenced with the Hyperlink editor?
Here is an example scenario for more clarification:
Insert → Hyperlink → Document → Target → cell name (e.g. A30) → Apply → Close
After inserting a row above the cell name, it would need to change to A31, since it shifted 1 row below, but this is not the case, because it still references to A30.
I would appreciate any advice.