To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718
------- Additional comments from pfeffer...@openoffice.org Fri Jan 9 16:53:05 +0000 2009 ------- 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 ). --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
