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

Op Fri, 30 Aug 2024 10:55:42 +0000
Gabriele Bertolucci <gabriele.bertolucci@protonmail.com> schreef:

> > Following the advice of Brian I renamed cell g:32731 in the vissen
> > sheet as lori_404 and in sheet L-nummers I created a hyperlink to
> > lori_404. Ctrl+k, document, target, add lori_404.
> >
> > Works great until I add/delete rows.
> >
> > Now when I click on the hyperlink in the L-number sheet I am
> > directed to the cell lori_404 in the fish sheet, but ... the cell
> > lori_404 is now in row 32769 which of course contains the wrong
> > name. In this case Hisonotus bourguyi.
> >
> > I probably doing something wrong here, but I can't figured out what.
>
> I think you are doing everything well. I don't see any wrong
> behaviour.
>
> When you set a reference to a cell via CTRL+K, you are not
> referencing "a floating cell", but a specific cell in a sheet,
> doesn't matter if you gave it a name.
>
> What you need is to define a Database Range (Data -> Define range), 
> setting also the flag "insert or delete cells".
>
> That range is usable in the same way as you used a Named Range in 
> CTRL+K, but will keep the reference live as you wish, no matter is
> the cell will be shifted.

Thanks, but for some reasons I can't make it work. It drives me crazy.

Right now I've set the datebase Range to $Vissen.$G$2:$G$36432

Is this correct?

Anyway below you'll find a link to the spreadsheet. There is nothing
secret on it.

Row 36432 of the sheet Vissen holds a new entry.
On sheet l-nummers only row 2 (Pterygoplichthys joselimaianus) and row
7 (Peckoltia oligospila) are holding a working link. 


Without sorting the links will work but after sorting Vissen to
place the new entry at the right spot (fron row 2 tot row 36432) like
this column 1: C
Column 2: D
Column 3: E
Column 4: G

the links aren't correct anymore.

I usualy add new entries, especially if there are lots of them at once,
on the last rows because it works faster this way.


https://u.pcloud.link/publink/show?code=XZiRMO0Z6QHQT3CJ7dVfeB9UsJ5EbHk576S7

Thanks for the help.

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