Op Fri, 30 Aug 2024 14:55:34 +0000 Gabriele Bertolucci <[email protected]> schreef:
> > 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? > > I think it's wrong. I tested a Database Range for a single cell, and > that's what you'll have to do: a single-cell-range for every link you > want to create. > Think about the range as the destination of the link for your needs: > how could it be composed of a group of cell? > > > 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. > > You are right. I've done more tests and indeed after sorting I > noticed Database Range was expanded to the entire column of numbers. > Link continues to work, bit it doesn't point to a single cell: it > point to the entire expanded range. > > Not what you were searching for. > > But I made other tests, and probably found the solution :-) > > Remember my previous posts, when I wrote to keep the flag "insert or > delete cells" on? > Well, I was wrong: if you DON'T KEEP ON that flag you will obtain the > effect you are searcing, even after sorting. > > Try it and give me a feedback. Sorry for the late reply. It seems not to work here. Whatever I try after sorting the hyperlink points to the wrong cell. I tried the setting "update references when sorting range of cells" on a smaller spreadsheet. This doesn't work either. On the original sheet this options crashes LO (out of memory). On W10 with this option set LO doesn't crash (98 % RAM usage) but it doesn't solve my problem. Anyway thanks for your 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
