Op Tue, 13 Aug 2024 16:19:39 +0100 Brian Barker <[email protected]> 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: [email protected] 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
