Created attachment 174915 [details]
The External Link dialog of attachment 166828 [details] 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 [details] and attachment 166828 [details] 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
The NamedRangeInOtherFile names range is !MonthNames instead of EDATAE13.xlsx!MonthNames
Recalculating the sheet replaces the cached value in B2 cell with a #NAME? error.
The NamedRangeInOtherFile names range should be EDATAE13.xlsx!MonthNames
Recalculating the sheet should keep the value in cell B2.
Version: 220.127.116.11.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
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.
Created attachment 174916 [details]
The Manage Names dialog of attachment 166828 [details] in Calc
Created attachment 174917 [details]
The document after recalculating
*** Bug 137847 has been marked as a duplicate of this bug. ***
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":
tdf#144397 tdf#144636 XLSX: cache external named ranges and their formulas
It will be available in 7.3.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Version: 18.104.22.168.alpha1+ (x64) / LibreOffice Community
Build ID: 73334560b2dd2d60ac58d2cc2b1a5295490b03e1
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU