https://bugs.documentfoundation.org/show_bug.cgi?id=138824
Bug ID: 138824
Summary: FILESAVE XLSX Link to external file loses parent
directory part if it points to file in parent
directory
Product: LibreOffice
Version: 7.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: filter:xlsx
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Blocks: 108917
Created attachment 168060
--> https://bugs.documentfoundation.org/attachment.cgi?id=168060&action=edit
Example file from Calc
When a formula targets a cell range in a file that is in the parent directory
of the files storing directory and the file is saved as XLSX, the parent
directory is lost and both Calc and Excel would start to find the target file
in the same directory.
Steps to reproduce:
1. Open attached file
2. Save as XLSX
3. Reopen in Calc or Excel
4. Observe the second parameter of VLOOKUP in cell D2 (or in Edit – Links
to external files / Data ribbon – Connections - Links)
Actual results:
Target files path changes from parent directory of current file to the
directory of current file.
Expected results:
Target files path unchanged.
LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 61d07657caab5e0fb8ec4446f67a7044e14dae4b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108917
[Bug 108917] [META] Cell references bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
