https://bugs.documentfoundation.org/show_bug.cgi?id=162530
Bug ID: 162530
Summary: Problem with INDIRECT in array context
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Start a new Calc document.
1. Enter 3 into cell A1.
2. Enter 4 into cell A2.
3. Enter =INDIRECT({"A1";"A2"}) into cell C1. Use here and in the following
steps instead of ";" the separator which is set in your LibreOffice as Array
column separator in tools > Options > Calc > Formula > section 'Separators'.
Finish entering with the 'Accept' icon left of the input line. You should get
value 3 in cell C1 and value 4 in cell D1.
4. Enter =SUM(INDIRECT({"A1";"A2"})) into cell C2. Finish entering with the
'Accept' icon left of the input line. You should get value 7 in cell C2.
5. Enter =SUM(INDIRECT({"A1";"A2"})) into cell C3. Finish entering with
Ctrl+Shift+Enter to force array context. You should get value 7 in cell C3,
because SUM function always adds all values even in array context and returns
one value.
Error: I get a 3 in cell C3 and a 4 in cell C4.
6. Do a hard recalculate, i.e. Ctrl+Shift+F9. It does not correct the error.
Save the file and reopen it.
Now the value in C3 is 7 as expected.
Having a 7 in C4 is an aftereffect of the wrong using of cell C4 in step 5.
--
You are receiving this mail because:
You are the assignee for the bug.
