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