Ask Your Question
0

Hyperlink fails when re-opening spreadsheet with error: "LINK TEXT" is not an absolute URL that can be passed to an external application to open it.

asked 2018-01-02 02:15:31 +0100

luke_airig gravatar image

My LibreOffice version is 5.3.6.1 (x64) on Win 8.1

I have an xlsx extension spreadsheet that has a hyperlink reference to pdf file irs_pub_915.pdf. The spreadsheet file and the pdf file reside in the same directory location C:\temp\junk.

I have the following 2 cells in my spreadsheet:

cell A1 text content : irs_pub_915.pdf

cell A2 hyperlink function content: =HYPERLINK("file://" & "/C:\temp\junk\" & A1, "LINK TEXT")

When I insert the hyperlink function into cell A2 and hover over cell A2, the following is displayed:

Ctrl-Click to follow link:file///C:\temp\junk\irs_pub_915.pdf

When I Ctrl-Click cell A2 the irs_pub_915.pdf opens as expected.

However, when I save, close and re-open the spreadsheet, when I hover over cell A2, the following is displayed:

Ctrl-Click to follow link:LINK TEXT

When I Ctrl-Click cell A2 the following message is displayed:

"LINK TEXT" is not an absolute URL that can be passed to an external application to open it.

The hyperlink appears to be losing track of the path to the external file.

Can anyone help me resolve this?

TIA

Luke

edit retag flag offensive close merge delete

Comments

(A suggestion: Reduce empty lines.)

Lupp gravatar imageLupp ( 2018-01-02 12:04:22 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-01-02 06:29:41 +0100

Jim K gravatar image

updated 2018-01-02 20:00:49 +0100

The problem also occurs with simpler formulas. Tested in LO 5.4.3.2:

=HYPERLINK("http://www.google.com/"; "LINK TEXT")

The problem does not occur when saving as .ods format. So for this as well as many other reasons, I would recommend saving as .ods instead of .xlsx. This fixes the problem instantly.

Also, the problem did not occur when tested with Apache OpenOffice 4.1.3. Not sure in what version of LibreOffice the problem was introduced.

You could file a bug at https://bugs.documentfoundation.org/. There are a number of hyperlink-related bugs, many of which only apply to .xls or .xlsx. After a brief search, I did not see any that are exactly the same as the issue described here. The bug has been reported at the link given by @Lupp.

edit flag offensive delete link more
0

answered 2018-01-02 12:03:38 +0100

Lupp gravatar image

I cannot test with files that were originally made with MS Excel as I have none.
When I just made a test file with LibO V6.0.0.0Beta2 under Win 10 saved to OOXML (.xlsx) the bug was still present.

See https://bugs.documentfoundation.org/b...
and in specific bug tdf#97805.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-02 02:15:31 +0100

Seen: 606 times

Last updated: Jan 02 '18