https://bugs.documentfoundation.org/show_bug.cgi?id=159378
Bug ID: 159378 Summary: In fods spreadsheets, external links to files in separate directories fail Product: LibreOffice Version: 7.6.4.1 release Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: dsmtng...@gmail.com Description: External file links between two fods spreadsheets in separate directories fail. This seems like a glaring bug, but I can't figure out what I am doing wrong. When the file with the reference is opened, a popup appears: "The following external file could not be loaded...". Updating the link with Edit->"Links to External Files", fixes the problem (though an incorrect path is still shown) until the file is saved and re-opened. I have not seen this behavior between ods files or if the two fods files are in the same directory. This happens independent of whether Tools->Options->Load/Save->General->"Save URLs relative to file system" is enabled or disabled. Steps to Reproduce: 1.Create two little fods spreadsheets: /home/xxx/Documents/LOtest/a/a.fods, constant value in cell A1 /home/xxx/Documents/LOtest/b/b.fods, cell A1 has an external reference to A1 in a.fods: ='file:///home/xxx/Documents/LOtest/a/a.fods'#$Sheet1.A1 2. This works until b.fods is closed and re-opened. On re-opening, an error is reported in a popup: "The following external file could not be loaded... file:///home/xxx/Documents/LOtest/b/a/a.fods". Note that directory a is shown to be a sub-directory of b, not a sibling. 3. Doing "Edit->Links to External Files" shows the incorrect path to a.fods, containing b/a. If one then does a Modify and selects b.fods with the correct path, the window still shows the incorrect path, containing b/a, but an Update will find a new value in a.fods. This works until b.fods and closed and re-opened, whereupon the link is again broken. Actual Results: Link to external fods file in another directory is broken after an open. Expected Results: After a fods file open, the file path in the link to an external file should be correct, and any cells correctly updated. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.4.1 (X86_64) Build ID: 60(Build:1) CPU threads: 2; OS: Linux 6.6; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Fedora 39, Workstation, with files on an ext4 file system -- You are receiving this mail because: You are the assignee for the bug.