[Libreoffice-bugs] [Bug 144397] New: FILEOPEN XLSX Named range is not resolved when it points to external file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144397
           Summary: FILEOPEN XLSX Named range is not resolved when it
                    points to external file
           Product: LibreOffice
           Version: Inherited From OOo
          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, varga.balazs3 at nisz.hu
            Blocks: 108897

Created attachment 174915
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174915&action=edit
The External Link dialog of attachment 166828 in Calc - good

This is split off from bug 137846
When a named range is defined in Excel such a way that it points to an external
file, Calc does not resolve the external file reference in the Manage Names
dialog and in the formulae that use this name.
The Edit – External Links dialog sees the connection to this target file
correctly, but recalculating the sheet or changing data in the target file
reveals that the named range does not work.

Steps to reproduce:
    1. Open attachment 166827 and attachment 166828 in Calc
    2. Press Ctrl-F3 to open the Manage Names dialog, see the
NamedRangeInOtherFile name
    3. Close the dialog and press F9 to recalculate the formulae

Actual results:
The NamedRangeInOtherFile names range is [1]!MonthNames instead of
EDATAE13.xlsx!MonthNames
Recalculating the sheet replaces the cached value in B2 cell with a #NAME?
error.

Expected results:
The NamedRangeInOtherFile names range should be EDATAE13.xlsx!MonthNames
Recalculating the sheet should keep the value in cell B2.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: c7b5e6566d9b24a0a996c739a945004d9aadee2f
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also happens in 7.0, 6.0, 5.3.
In 5.2 and before not even the connection to the external file was imported
correctly in the External Links dialog.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
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/20210909/6a86bc40/attachment-0001.htm>