Is it possible to have more than one hyperlink defined by formulae in the same cell of Calc?

I know it is possible with hyperlinks created via the corresponding dialogue called by Ctrl-K. But I am interested in hyperlinks defined by the HYPERLINK() function. Can one put several such links into one cell?

It doesn’t work to combine formulas using something like HYPERLINK() & "," & HYPERLINK() (at least in my 7.1.0.3 version), though I’d consider this a bug,.

This never worked.

Cells containing more than one hyperlink need to have inserted them as TextField objects, and functions can only return a number or simple text (a string) to the cell they are called from. A routine can create the textfields and insert them into a cell in principle. However, a function should not try to do so with a cell contained in the same sheet the formula is contained in. It can be done with output to a different sheet.
See demo. (Made with V7.1.1.1 just for fun. Don’t think it’s of much use.)
ask295528multipleLinks_1.ods

Your knowledge of LO clearly greatly exceeds mine, so I am not sure I completely understand what you have written. That did not prevent me from playing with you demo file, though.

Most likely, this is a stupid question and I am sorry in advance, but… why does the formula work in your file, but not in mine? I copied and pasted its text to exactly the same cell and all I have got is #NAME?. Why is that? Does your file have any special properties?

I forgot to mention that I copied the macros from your file to my file as well, of course.

Well, it started working after Calc’s relaunch. Not sure why, but I do not care much, frankly. And it works exactly as I want it to! So let me humbly disagree with your last sentence in parenthesis. This is complex, but absolutely brilliant, quite workable solution. Being such it will see a lot of use in my files (I suppose my colleagues at work will find if it helpful as well). You have my sincerest gratitude!

As I already told I regard the function rather a toy - and functions with side-effects manipuöating cels are always a bit(?) problematic.
However, if you want to use the function it on a regular basis, you should move it to a suitable module of you local Standard library of MyMacros.
Always keep in mind that sheet using such functions cannot simply be passed to someone else.

Just for fun I meanwhile “modernized” the clearing of the target cell to get rid of a little problem, and tested the macro also omitting the second sheet. it seemed to work.
Anyway: Functions with side-effects in the same sheet are generally deprecated. Behaviour can be changed without notice, See new attachment made with V7.1.1.1.
ask295528multipleLinks_2.ods

This version works just as nicely as well. Thank you very much again.

Out of mere curiosity, what do mean you when saying «function with side-effects»? I presume this is your own terminology, is it?

The term is common.
Generally a function is a subroutine expected to exclusively calculate a result from given values (passed as arguments replacing the formal parameters or via variables with a scope including the body of the function) and to return it (the result) to the position inside an expression from where it (the function) was called. This position must be able to accept the type/format of the returned result.
An enhanced concept also allows the function to change the values of arguments (called by reference). The respective parameters are sometimes called “transient”.
Any additional effect caused by a run of the function is called a side-effect. See Side effect (computer science) - Wikipedia.
In the given case the function only returns a trivial “result” (done or nothing). The actually intended effects are all side effects afflicting a cell elsewhere which is given by a reference passed as the first argument. (to be continued–>)

(—> continued)
Since the function doesn’t change the passed reference but the cell itself (some of it’s properties) this first argument isn’t exactly a transient, but a handle to direct side-effects.

I appreciate your clear explanation.