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: [email protected]
Reporter: [email protected]
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.
