https://bugs.documentfoundation.org/show_bug.cgi?id=145994
Bug ID: 145994 Summary: references to named ranges in external files do not update on document open Product: LibreOffice Version: 7.2.2.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: zapst...@gmail.com Description: The "Manage Name" menu appears to be accessible only through the drop-down menu with cell number displayed, above the spreadsheet number column, on the left side of the window. When a named range references a named range in another file, the data from that named range does not update on file opening, even if "Allow updating" is selected. References to the named range appear as #NAME? unless the named range is touched by opening the Manage Name window and clicking on the range specification. Steps to Reproduce: Create a file, reference_values.ods, which has a table of values: A B 1 fruit qty 2 apple 10 3 orange 6 4 banana 42 5 kiwi 12 Name the range by clicking on Manage Names and defining as: fruit: $sheet1.$a$2:$b$5 Save the file, and create a second file, calculations.ods. Select Manage Names, and define a new named range: fruit: ‘file:///c:/users/me/documents/reference_values.ods’#fruit In the worksheet, create a table A B 1 fruit qty 2 apple =vlookup(a2,fruit,2,0) 3 orange =vlookup(a3,fruit,2,0) 4 banana =vlookup(a4,fruit,2,0) 5 kiwi =vlookup(a5,fruit,2,0) Save and close both files; close calc. Open Calc, and load calculations.ods. When prompted with a warning about automatic updating being disabled, click on the “Allow updating” button. Hit f9 or ctrl+shift+f9 to force an update; the #NAME? errors remain. Click on “Manage Names”; select fruit; click on “Range for formula expression”… do not make any changes to the expression; close Manage Names window. The #NAME? references change from the Actual Results to the Expected Results. Actual Results: fruit qty apple #NAME? orange #NAME? banana #NAME? kiwi #NAME? Expected Results: fruit qty apple 10 orange 6 banana 42 kiwi 12 Reproducible: Always User Profile Reset: No Additional Info: Version: 7.2.3.2 (x64) / LibreOffice Community Build ID: d166454616c1632304285822f9c83ce2e660fd92 CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: en-CA (en_CA); UI: en-US Calc: CL -- You are receiving this mail because: You are the assignee for the bug.