[Libreoffice-bugs] [Bug 123790] New: INDIRECT function shows #REF! for sheet-scoped named range references (SheetName . RangeName)

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: argrico at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190301/66cc455c/attachment.html>