Any way to create a drop-down menu list with hyperlinks on Calc?

[Moshpirit]

I find drop-down lists very useful, but I’m not sure if it’s possible to attach hyperlinks in any way. I thought about forms, but I still can’t find how to do that through this tool either.

[Moshpirit]

Found the solution: using Hyperlink formula, with URL between ".

It can be implemented by using Data → Validity → List; and including the formulas.
Eg:

=hyperlink("https://libreoffice.org/";"LibreOffice website is great!")
=hyperlink("https://ask.libreoffice.org/";"LibreOffice forum is so helpful!")
=hyperlink("https://www.libreofficehelp.com/";"Click here for some LO tutorials!")

[toodleloo]

i want to do this but it just replaces the content in my current cell with “=hyperlink(“link”)” when I click on the link, and when I add a string value after the link like “=hyperlink(“link;stringvalue”)” it just returns “stringvalue” into my current cell instead of activating the link

[erAck]

You might be interested in reading the HYPERLINK() help.