https://bugs.documentfoundation.org/show_bug.cgi?id=159082
Bug ID: 159082
Summary: Calc INDIRECT() links faulty in folders other than
~/documents on FILEOPEN
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:
Disclaimer: This is the German version of LibreOffice on German Linux, so in
fact it's INDIREKT() and ~/Dokumente. Maybe the bug happens only in that
setting.
In a Calc spreadsheet, in a cell I have a link to another file like this:
=INDIREKT("'./Testdaten.ods'#$Tabelle1.B2")
If both files are in ~/Dokumente, and I reopen the file with the link, I get a
message that the links ("Verweise") weren't updated. I can allow the update and
everything looks ok.
If both files are anywhere else, on clicking "allow update" I get a warning
that the link couldn't be found, but then it is updated regardless. In
"Bearbeiten->Verknüpfungen zu externen Dateien..." (edit->links to external
files) I see that 2 absolute links have been created, one to
file:///home/jochen/Dokumente/Testdaten.ods and one to <real
location>/Testdaten.ods. If I delete any of the 2 links, the INDIRECT() is
replaced with the referred value.
Steps to Reproduce:
1. change to a folder other than ~/Dokumente
2. create an .ods with some test data
3. create an .ods with a link to that test data
(=INDIREKT("'./filename.ods'#$sheet.cell")
4. close and reopen the file with the link
5. allow updates
6. choose "Bearbeiten->Verknüpfungen zu externen Dateien..."
7. delete the wrong link there
Actual Results:
- warning on "allow updates"
- 2 absolute links in "Verknüpfungen", one correct, one to
"~/Dokumente/filename.ods" as absolute path
- deleting the wrong link replaces the INDIREKT() link with the linked data.
Expected Results:
- no warning
- 1 correct link in "Verknüpfungen", either relative or absolute
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.4.1 (X86_64)
Build ID: 60(Build:1)
CPU threads: 8; OS: Linux 6.6; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
