How to add a text form hyperlink that display PART NOT ALL of content in a cell in LibreOffice Calc? [closed]

asked 2013-04-28 04:22:53 +0100

Tiber gravatar image

I have a spreadsheet with 2 sheets, and the content in A1 in Sheet1 is "Description, see Figure 1". I wanna insert a text form hyperlink in Sheet1.A1 that display ONLY "Figure 1" and pointing to Sheet2. What I do is select the text "Figure 1", then click Inert->Hyperlink, in the Hyperlink Dialog I set Target to Sheet2 and leave other options to default. So far the content in Sheet1.A1 doing all I want, BUT if I close LibreOffice Calc and reopen the file, it changed, ALL the content in Sheet1.Al now became the display of the hyperlink. What can I do? Is it a BUG? Please help, thanks!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 18:57:03.773342