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

Op Tue, 13 Aug 2024 20:07:39 +0200
Martin /Nightowl/ Byttebier <tos4ever@telenet.be> schreef:

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

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