[libreoffice-users] question hyperlinks in Calc.

Hello,

I have a spreadsheet with four sheets: "Vissen," "L-nummers," "CW," and
"Verwerking."

I want to create a hyperlink in a cell on one sheet (e.g., "L-nummers")
that links to a specific cell in another sheet (e.g., "Vissen").

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 because the
original cell became "f31510" or something similar.

My question is: Is there a way to make the hyperlink automatically
point to the correct entry, even if rows are added or deleted?

Ideally, I would like the hyperlink to automatically update based on
the target entry. I tried using the formula =$Vissen.f31500 in the
"L-nummers" sheet, which works, but it doesn't create a hyperlink.

Is there a way to achieve this?

Kind regards,
Martin

-- 

Atari FTP-site: ftp://kurobox.serveftp.net:3021
Running openSUSE Tumbleweed / KDE 6.1.4

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