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

At 16:57 13/08/2024 +0200, Martin Byttebier wrote:
> I want to create a hyperlink in a cell on one sheet ... that links 
> to a specific cell in another sheet ...
> Initially, I used Ctrl+K to add a hyperlink and set the target to a 
> specific cell, such as "Vissen.f31500." This worked fine until I 
> added some rows to the "Vissen" sheet. The target cell shifted, and 
> "Vissen.f31500" no longer pointed to the correct entry ...
> My question is: Is there a way to make the hyperlink automatically 
> point to the correct entry, even if rows are added or deleted?

I *think* that if you ascribe a name to the target cell and create 
the hyperlink to that name instead of to the cell address, you will 
achieve what you require.

I trust this helps.

Brian Barker


--
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