https://bugs.documentfoundation.org/show_bug.cgi?id=123790
Bug ID: 123790
Summary: INDIRECT function shows #REF! for sheet-scoped named
range references (SheetName . RangeName)
Product: LibreOffice
Version: 6.1.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
For page scoped range names, =SheetName.RangeName does work, but
=INDIRECT("SheetName.RangeName") it shows #REF!
Steps to Reproduce:
1.Open new Spreadsheet with sheets "Sheet1" and "Sheet2"
2.Set Sheet1.A1 =XXX
3.Define a new named range:
- Select Sheet1.A1
- Sheet > Named Ranges and Expressions > Define...
Name: MyNamedRange
Range or formula expression: $Sheet1.$A$1
Scope: Sheet1
4.Verify that the named range works:
- Set Sheet2.A1 =Sheet1.MyNamedRange
The cell displays: XXX
5.Refer to the Cell using INDIRECT:
- Set Sheet2.B1 =INDIRECT("Sheet1.MyNamedRange")
Actual Results:
#REF!
Expected Results:
XXX
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
