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: [email protected]
Reporter: [email protected]
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.
