[Libreoffice-bugs] [Bug 138824] New: FILESAVE XLSX Link to external file loses parent directory part if it points to file in parent directory

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org, szucs.attila3 at nisz.hu
            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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201211/1e750d55/attachment.htm>