[FMEA] Automatically use Cell's Content for Hyperlink Text (when linking to that cell)?

[eacousineau]

Is there a way to have a hyperlink to a cell automatically use the cell’s content as text?
To hyperlink to a cell, I manually add in a Named Range just for that cell (to account for shifting cells around), and then reference that as the target.

I am making an FMEA document based on ASQ’s example, and would like to automate relational mapping so I can use a Python API to perform Cause Analysis, producing GraphViz docs, etc.
(And by the way, if anyone knows of such existing solutions, please let me know!)

System

• LibreOffice 3.5.7.2, English, Build ID: 350m1(Build:2)
• Component: Calc
• Operating System: Ubuntu 12.04, English

[mariosv]

I`m not sure If I understand what you are asking, but I think HYPERLINK() function can help Hyperlink() help, you can use instead of text parameters, cell references.

[eacousineau]

That effectively does what I asked for!
However, I then realized I would like to embed multiple hyperlinks on one cell It seems like Hyperlink does not fare well with string concatenation. Marking this question as answered, though!

[mariosv]

I think there is no option for several links in the same cell. And I doubt it will ever be.