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

Op Fri, 30 Aug 2024 14:55:34 +0000
Gabriele Bertolucci <gabriele.bertolucci@protonmail.com> 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: 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