[Libreoffice-bugs] [Bug 138832] New: FILESAVE XLSX Updating external link used in formula does not save the updated link

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138832
           Summary: FILESAVE XLSX Updating external link used in formula
                    does not save the updated link
           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 168077
  --> https://bugs.documentfoundation.org/attachment.cgi?id=168077&action=edit
Example file from Calc

Attached file contains a simple cell reference to another file.
If this is changed to point to another file and saved to XLSX then upon reload
the target file name incorrectly appears as [2].

Steps to reproduce:
    1. Open attached file
    2. Change the D2 cells target file name from  tdf132105_external.ods to
87973_externalSource.ods
    3. Save the file as XLSX, reopen

Actual results:
D2 cells target becomes =[2]sheet1!b3
Edit – Links to external files shows two entries: the correct link to the new
target file and “[2]”.

Expected results:
D2 cells target is the 87973_externalSource.ods

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: 61d07657caab5e0fb8ec4446f67a7044e14dae4b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; 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/e975747a/attachment.htm>