Can't create relative hyperlink in Calc

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?

EDIT:

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?

Menu/Tools/Options/LibreOffice/Load&Save/General - Save URLs relative to file system.

Relative file system path

The option was ticked on as default. Ticking it off meant that I wasn’t able to save hyperlinks with relative paths any longer, the link would have no target when re-opening the file. Will be adding extra information to the original question to address this answer as well as additional findings.