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

Op Tue, 13 Aug 2024 16:19:39 +0100
Brian Barker <b.m.barker@btinternet.com> schreef:

> 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

Thanks. But that's not really doable in my case. The cw-sheet holds 600
entries of which some 300 must be linked. Too much time consuming and
prone to mistakes.

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