How can I enter a reference to another file using a relative path?
At the moment. As soon as I enter
this is converted immediately to
by LibreOffice Calc.
The idea is that I can move the parent directory around (it is in a Dropbox) and the references are still intact.
I do not see any docs about it at the official References to Other Sheets and Referencing URLs. Searching the web reveals some notes to enable ‘Save URLs relative to file system’ under ‘Tools’ > ‘Options’ > ‘Load/Save’ > ‘General’ > ‘Save’, but it is already enabled on my computer.
This is with LibreOffice 184.108.40.206 on Ubuntu 16.04.