Op Fri, 30 Aug 2024 10:55:42 +0000 Gabriele Bertolucci <[email protected]> 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: [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
