Issue 127898 - Array reference indirected to a nonexistent sheet is silently redirected to first sheet.
Summary: Array reference indirected to a nonexistent sheet is silently redirected to f...
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.5
Hardware: PC Windows 10
: P5 (lowest) Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-09-19 02:26 UTC by dmcilroy
Modified: 2018-09-19 02:26 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
see comment (8.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-09-19 02:26 UTC, dmcilroy 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dmcilroy 2018-09-19 02:26:47 UTC 
Created attachment 86511 [details]
see comment

Refer to the attached example spreadsheet.

Cells A1:A3 of each sheet contain keys A,B,C in distinctive orders.

Columns B,C,D of Sheet2 locate (via MATCH) occurrences of Sheet2's keys on other sheets, whose numbers are designated in row 6.

Column B uses indirection; the target sheet can be changed by changing B6. Play with it to see the following  phenomena.

When B6 is 1 or 3, column B agrees with column C (addressing Sheet1) or D (Sheet3) respectively.

When B6 is outside the range 1-3, the formulas in B1:B3 refer to a nonexistent sheet. Calc does not report the error. It takes the first sheet to be the target instead. Thus B1:B3 becomes the same as C1:C3.