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

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

-- 
Gabriele Bertolucci



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