[sc-issues] [Issue 72718] Multiple Operations proble m
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 hon...@openoffice.org Mon Jan 12 00:46:09 + 2009 --- As n...@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. - 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
[sc-issues] [Issue 72718] Multiple Operations proble m
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 + 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
[sc-issues] [Issue 72718] Multiple Operations proble m
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 n...@openoffice.org Fri Jan 9 13:54:40 + 2009 --- 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. - 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
[sc-issues] [Issue 72718] Multiple Operations proble m
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 13:20:27 + 2009 --- 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. - 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
[sc-issues] [Issue 72718] Multiple Operations proble m
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 n...@openoffice.org Fri Jan 9 10:12:21 + 2009 --- *** Issue 97882 has been marked as a duplicate of this issue. *** - 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
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |er Target milestone|--- |OOo Later --- Additional comments from [EMAIL PROTECTED] Thu Jan 18 05:48:00 -0800 2007 --- Hi Eike, I think it's a double but could not find it. If so, please close otherwise proceed as needed. Frank - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User kpalagin changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41670) Screenshot --- Additional comments from [EMAIL PROTECTED] Sat Dec 23 03:26:47 -0800 2006 --- Created an attachment (id=41670) Screenshot - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User kpalagin changed the following: What|Old value |New value CC|'yba' |'kpalagin,yba' --- Additional comments from [EMAIL PROTECTED] Sat Dec 23 03:25:42 -0800 2006 --- 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. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User ayaniger changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41513) Spreadsheet with bo | |th examples (sheet 1 and s | |heet 2) --- Additional comments from [EMAIL PROTECTED] Mon Dec 18 05:04:20 -0800 2006 --- Created an attachment (id=41513) Spreadsheet with both examples (sheet 1 and sheet 2) - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User ayaniger changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41512) SUM(x:y) - error --- Additional comments from [EMAIL PROTECTED] Mon Dec 18 05:03:16 -0800 2006 --- Created an attachment (id=41512) SUM(x:y) - error - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 User ayaniger changed the following: What|Old value |New value Attachment data| |Created an attachment (id= | |41511) SUM(x;y) - no error | | --- Additional comments from [EMAIL PROTECTED] Mon Dec 18 05:02:30 -0800 2006 --- Created an attachment (id=41511) SUM(x;y) - no error - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 72718] Multiple Operations proble m
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72718 Issue #|72718 Summary|Multiple Operations problem Component|Spreadsheet Version|OOo 2.1 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ayaniger --- Additional comments from [EMAIL PROTECTED] Mon Dec 18 05:00:13 -0800 2006 --- 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. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]