I have a spreadsheet on which one of the columns must be an hyperlink to an external file. The hyperlink is static, and as such is being created by using the Insert->Hyperlink option. I have tried selecting the file from the file picker, inputting the relative file path directly, and even by placing the external files in the same folder as the spreadsheet and just inputting the filename.
All the created links seem to work perfectly, but upon saving and re-opening the document, I can see that Calc is trying to find the file using its last known absolute file path. This of course means that when I open the file in a different computer or OS, the links are broken.
Is there a way to create purely relative hyperlinks (that stay relative after saving and re-opening) with the Insert->Hyperlink option?
The “Save URLs relative to file system” option is checked, unchecking it produces broken hyperlinks when the file is re-opened (as in, hyperlinks with no target).
I ran some experiments by creating several different hyperlinks, saving and then opening the content.xml file inside the ODS container to see what was really being written to disk. It seems the only way Calc will save the relative path properly is when the file is selected using the file picker. Now the question becomes, is there a way to get the correct, expected behavior without using the file picker, to save time?