Op Tue, 13 Aug 2024 20:07:39 +0200 Martin /Nightowl/ Byttebier <[email protected]> schreef:
> 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 > -- > I followed your advice anyway but ... your solution doesn't seem to work. The sheet “fish” contains almost 37,000 rows and rows are still being added daily. The second sheet contains about 600 rows. From the second sheet, links are created to the first sheet. How to proceed. In the fish sheet I select the desired cell and give it a name via managed names. Eg. lori_006 In range I see e.g. this $Fishes.$G$32953 Scope: global Range option: empty But after some time, i.e. after adding dozens of new rows, it is no longer correct. The link lori_006 in de second sheet still refers to cell G32953 in the first sheet but ... not to the correct one. The correct cell has since become G33189. Probably I am doing something wrong, but what? It has maybe something to do how I add the rows. If I add, let us say 50 new rows, I do this by adding empty rows at the very end of the sheet. I do my thing and when finished I sort the whole thing. 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
