[Libreoffice-bugs] [Bug 137937] New: FILESAVE XLSX External cell reference path is extended by user home dirs path

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137937

            Bug ID: 137937
           Summary: FILESAVE XLSX External cell reference path is extended
                    by user home dirs path
           Product: LibreOffice
           Version: 4.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, filter:xlsx, implementationError
          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 166941
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166941&action=edit
Example file from Calc with cell references to c:\TEMP

Attached ODS file contains a cell reference to a file in C:\TEMP directory.
When this file is saved to XLSX format the path to the file is extended with
the users home directory name, i.e.
='file:///C:/TEMP/EDATAE13_B.xlsx'#$Munka1.A1 becomes
='file:///C:/Users/kelemengabo/Documents/TEMP/EDATAE13_B.xlsx'#$Munka1.A1 
This is similar to the situation mentioned here for Linux:
https://bugs.documentfoundation.org/show_bug.cgi?id=121472#c5 

Steps to reproduce:
    1. Open attached file
    2. Save as XLSX
    3. Reopen

Actual results:
Cell reference path changed, now it contains thes users own directories path.

Expected results:
Correct cell references.

LibreOffice details:
Version: 7.1.0.0.alpha1+ (x64)
Build ID: ec1f4d3253963ac16d638734ac70dde033e82154
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also happens way back to:
Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: hu_HU

In 4.3 the exported reference was:
=['file:///c:/temp/edatae13_b.xlsx']munka1!a1
Which had a correct path, but it was otherwise incorrect and giving Err:509
error.

Additional Information: 

Bibisected using bibisect-win32-4.4 to:
https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=5c37960d9507fac206f0b90d36f778db9fe2b6a5..41e4a607b00f446eeaebf8f59c957a1a580c9517

of which the most likely starting commit is the initial implementation of this
feature:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=8c23a767d926d8d08213f5e2f8e81775c653cbd7 

write OOXML externalReferences, externalLinks, fdo#45286


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/20201102/da370719/attachment.htm>