Ask Your Question

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

asked 2014-02-23 21:29:04 +0100

eacousineau gravatar image

updated 2015-09-12 03:36:35 +0100

Alex Kemp gravatar image

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


  • LibreOffice, English, Build ID: 350m1(Build:2)
  • Component: Calc
  • Operating System: Ubuntu 12.04, English
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:49:09.331787

1 Answer

Sort by » oldest newest most voted

answered 2014-02-23 23:42:35 +0100

m.a.riosv gravatar image

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.

edit flag offensive delete link more


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!

eacousineau gravatar imageeacousineau ( 2014-02-28 01:34:57 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2014-02-28 01:54:37 +0100 )edit

Question Tools

1 follower


Asked: 2014-02-23 21:29:04 +0100

Seen: 422 times

Last updated: Feb 24 '14