Bug 123790 - INDIRECT function shows #REF! for sheet-scoped named range references (SheetName . RangeName)
Summary: INDIRECT function shows #REF! for sheet-scoped named range references (SheetN...
Status: RESOLVED DUPLICATE of bug 100818
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-01 15:36 UTC by Alberto
Modified: 2019-03-01 22:03 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Test case that demonstrates the reported bug. Sheet2.B1 shows #REF! instead of XXX (7.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-03-01 15:39 UTC, Alberto 		Details
LibreOffice-Calc-TestCase XSLX (10.82 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-01 18:06 UTC, Oliver Brinzing 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alberto 2019-03-01 15:36:42 UTC 
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:
Comment 1 Alberto 2019-03-01 15:39:31 UTC 
Created attachment 149677 [details]
Test case that demonstrates the reported bug. Sheet2.B1 shows #REF! instead of XXX

The example file documented in the bug.
Comment 2 Oliver Brinzing 2019-03-01 18:06:46 UTC 
Created attachment 149679 [details]
LibreOffice-Calc-TestCase XSLX

i can see the problem, but i am not sure if this is a bug,
cause ms excel 2016 will show an error too.
Comment 3 m_a_riosv 2019-03-01 22:03:31 UTC 

*** This bug has been marked as a duplicate of bug 100818 ***