[Libreoffice-bugs] [Bug 137847] New: FILESAVE XLSX Named range pointing to data range in external file breaks

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137847
           Summary: FILESAVE XLSX Named range pointing to data range in
                    external file breaks
           Product: LibreOffice
           Version: 7.1.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: 104839, 137805

Created attachment 166830
  --> https://bugs.documentfoundation.org/attachment.cgi?id=166830&action=edit
Data source file with data table from Excel

Attached Excel made file contains a named range that points to an external file
and references an Excel Tables values by their columns name.
When this file is saved unchanged in Calc and reopened in Excel, it finds
invalid contents.

Steps to reproduce:
    1. Open attached file, check Edit – Links to external files: link is there
    2. Save as XLSX and open it in Excel.

Actual results:
External file reference not saved, Excel indicates broken named range on open.

Expected results:
External file reference saved.

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

Note: this may be a consequence of bug #137846 but filing just in case it's
not.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=104839
[Bug 104839] [META] Saved XLSX files that MS Excel can't open
https://bugs.documentfoundation.org/show_bug.cgi?id=137805
[Bug 137805] [META] XLSX (OOXML) Data range / Format as Table issues
-- 
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/20201029/08c5eaf0/attachment-0001.htm>