https://bz.apache.org/ooo/show_bug.cgi?id=127898
Issue ID: 127898
Issue Type: DEFECT
Summary: Array reference indirected to a nonexistent sheet is
silently redirected to first sheet.
Product: Calc
Version: 4.1.5
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Major
Priority: P5 (lowest)
Component: programming
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86511
--> https://bz.apache.org/ooo/attachment.cgi?id=86511&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the issue.
