I did a search before I submitted this question but unfortunately nothing specific to my issue came up. So here I am…
I have a spreadsheet with a column (column A) listing hundreds of local files complete with its path (/path/to/folder of pictures/picture001.png through /path/to/folder of pictures/picture999.png). In another column (column B) I have only the filenames of the PNGs from column A (thanks to this nice bit of REGEX).
Now, in column C I have created the formula
=HYPERLINK($A1;$B1) and filled down the rest of the entries. In theory, when I cmd-click on a cell in column C, LO should open the referenced PNG. And it does…sometimes! But more often than not I’m getting the dreaded
"file:///path/to/folder of pictures/picture003.png" is not an absolute URL that can be passed to an external application to open it.
The paths entered in column A are correct (I double-checked), the files referenced in column A exist (I double-checked) and are valid, and I also checked to see that
Preferences > Load/Save > Save URLs relative to file system is selected.
I came across this question and followed the bug reports but the issue has since been closed. Am I doing something wrong? Could it be the spaces in the path are causing problems? But then, why do some links work correctly and others don’t? Should I file another bug report?
Thanks! – gt
EDIT: Version: 18.104.22.168, Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8, Mac OS X 10.13.6
EDIT 2: a much-reduced example of the document I’m working on. C:\fakepath\test_ods.zip.ods Change the extension to “.zip” and extract. PLEASE: the attached files are copyrighted and are included solely for demonstration purposes. Please delete after testing. Thank you