https://bugs.documentfoundation.org/show_bug.cgi?id=148983
Bug ID: 148983
Summary: MULTIPLE.OPERATIONS fail with Err:504 when the input
cell is *part* of the range used in formula cell
directly
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
URL: https://ask.libreoffice.org/t/calc-getting-list-of-out
put-values-for-a-set-of-input-values/77238/
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
In a new Calc document:
1. Put number '1' to A1, A2, A3 and A4
2. Put formula '=SUM(A1:A4)' to A5
3. Put number '2' to B1
4. Select B1:C1, and call Data->Multiple Operations
5. Put 'A5' to dialog's "Formulas", and 'A2' to "Column input cell", and click
OK.
=> C1 shows Err:504.
It depends on the range used in the A5 formula. Having the formula changed to
'=SUM(A2:A2)' (note that it also uses reference to a range including the input
cell, but only that cell!), or to '=SUM(A3:A4)' makes it function OK. Seems
like the range gets "broken" when we use another cell for updated value for
some cell inside the range.
Also repro using OOo 3.3.0.
--
You are receiving this mail because:
You are the assignee for the bug.
