Internal links:, referencing:, UI: adapt internal links when copying cells - enhancement proposal.
Short: would like relative references in 'internal links' to
be adapted for copies in the same manner as formulas are.
Actual observed: kept as absolute. Simple reproducer:
new sheet,
'1' in B2,
'=B2' in C2,
right-click C2 and 'Add Hyperlink', internal, to B2,
left click on C2 now jumps to B2.
Copying C2 to C3 adapts the formula to a
new 'same relative' position, 'B3', and the displayed result
changes to '0', but the link reference is kept unchanged to B2,
left-clicking C3 doesn't jump to B3 as simple minded users might
expect, but to B2.
Would like to see:
Link changed to 'B3' as well, click jumping to B3.
Long: - Click to expand
The general concept in gnumeric is 'referential integrity'?
Keeping 'absolute' references intact when copying or moving
cells, while relative references are adapted for moves and
'created new' - to same relative! position - for copies.
Same does not apply when copying cells containing 'internal links',
relative references in the link are kept like absolute also
in copying.
My use case: I'd like to produce some 'hierarchical structur'
where pairs of cells bilateral linking to the partner could serve to
jump from the table of contents to a chapter, and back from there
to the index-point in the table of contents. Producing them by
multiple copies would be much more convenient than manual edit.