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 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.
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": https://git.libreoffice.org/core/commit/12ee423c7549ddd2b86dfc3fc6fed2c617dcca7f 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.3.0.0.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 Calc: threaded