Re: [libreoffice-users] question hyperlinks in Calc.

> Following the advice of Brian I renamed cell g:32731 in the vissen
> sheet as lori_404 and in sheet L-nummers I created a hyperlink to
> lori_404. Ctrl+k, document, target, add lori_404.
>
> Works great until I add/delete rows.
>
> Now when I click on the hyperlink in the L-number sheet I am directed
> to the cell lori_404 in the fish sheet, but ... the cell lori_404 is now
> in row 32769 which of course contains the wrong name. In this case
> Hisonotus bourguyi.
>
> I probably doing something wrong here, but I can't figured out what.

I think you are doing everything well. I don't see any wrong behaviour.

When you set a reference to a cell via CTRL+K, you are not referencing 
"a floating cell", but a specific cell in a sheet, doesn't matter if you 
gave it a name.

What you need is to define a Database Range (Data -> Define range), 
setting also the flag "insert or delete cells".

That range is usable in the same way as you used a Named Range in 
CTRL+K, but will keep the reference live as you wish, no matter is the 
cell will be shifted.

-- 
Gabriele Bertolucci



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy