Apache OpenOffice (AOO) Bugzilla – Issue 72718
Multiple Operations problem
Last modified: 2019-08-13 11:07:31 UTC
When I choose a cell with a SUM function as the formula for Multiple Operations, the results will only work for if the function is SUM(x;y), but not for SUM(x:y) (with a range). See screenshots.
Created attachment 41511 [details] SUM(x;y) - no error
Created attachment 41512 [details] SUM(x:y) - error
Created attachment 41513 [details] Spreadsheet with both examples (sheet 1 and sheet 2)
Confirming with OO 2.1 on WinXP - if I change formula in cell A3 from "SUM (C1+C2)" to "SUM((C1:C2)" calculation fails. I am attaching screenshot, where problematic formula is circled in red.
Created attachment 41670 [details] Screenshot
Hi Eike, I think it's a double but could not find it. If so, please close otherwise proceed as needed. Frank
*** Issue 97882 has been marked as a duplicate of this issue. ***
very strange: alway someone says 'using ranges in Multiple Operation" doesn't work. But if you replace in the last posted example ( http://www.openoffice.org/ nonav/issues/showattachment.cgi/41513/MultipleOperationsExample.ods "MultipleOperationsExample.ods") in cell E16 the function "=match(0;D2:D14;0" by "=sum(0;D2:D14;0)", the sum is calculated correctly --> the reasons of failing must be more complex.
pfeffer2de, are you mixing this up with issue 39304? That's a different problem, and there the input cell D16 is used with a single-cell reference in D2.
I'm astonoished about what is the difference of the problems. issue 39304 doesn't directly reference the input cell by a range, but does so indirectly: the input cell is referenced by the output cell E16 by a function (originally "match", alternatively try "sum") by a range, which references the input cell. --> ok, I tried: a generally workaround is: using inderect references to the input cell if you want to use a cell as input cell being in a range. E.g. instead of using "=sum(a1:a2)" in the output cell, entder in a cell B1 "=sum (a1:a2)" and reference it by the output cell "=b1". That works. Ok, then I understand, why you say, that it's a different thing: directly referencing the input cell as part of a range is not allowed (as in the issue 39304), indirectly causes problems (only?) when lookup functions (is multiple.operation itself a "lookup funktion"?) are involved. To summerize: 1. there are cases in which the multiple.operations functions works correctly. 2. you never can be sure that this is the case. I suggest: remove this function or make it work correctly. It is absolut inaccaptable to get wrong results without being warned or even to know in which cases this happens. See my issue 96803 ( http://www.openoffice.org/issues/ show_bug.cgi?id=96803 ).
As nn@openoffice.org said in issue #97882 that this is a limitation of current implementation. So way forward, is it targeted for fix in ver. 3.1? So far, I don't see that and this bug is more than 2 years.
Reset assigne to the default "issues@openoffice.apache.org".
I just encountered the same issue. Are there any plans to fix this? Is MULTIPLE.OPERATIONS not a stable feature? I also started a thread here: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=98966