[sc-issues] [Issue 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 User er changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Mon Aug 4 11:56:18 + 2008 --- @regina: Thanks for the ODF comment, I noted that down to be checked in the spec. Closing 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: [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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 --- Additional comments from [EMAIL PROTECTED] Sun Aug 3 07:10:25 + 2008 --- I understand that the ODF specs do not allow you to change the definition of the SUMPRODUCT function. However, now that you suggest an alternative formula for the OOo calculation, that Excel does not like, I can provide you with one formula that Excel likes: =SUMPRODUCT(MMULT(($A$2:$A$4=$A$9)*1;($B$1:$D$1=$A$10)*1)*$B$2:$D$4) I just added the '*1' factors to the logical vectors so that Excel could make the calculation. So we found one compatible formula!!! - 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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92402
User regina changed the following:
What|Old value |New value
CC|''|'regina'
Status|UNCONFIRMED |RESOLVED
Keywords| |oooqa
Resolution| |DUPLICATE
--- Additional comments from [EMAIL PROTECTED] Sat Aug 2 14:37:55 +
2008 ---
It is no defect in SUMPRODUCT, but it is the question how operators and
functions, which expect a single value as argument, shall work, if they get an
array as argument. This is already handled in issue 46681.
Currently OOo evaluates {1|0|1}*{1;0;1} to {1;#NV;#NV|#NV;#NV;#NV|#NV;#NV;#NV}
and Excel evaluates it to {1;0;1|0;0;0|1;0;1}.
Unfortunately I find no rule in the ODF spec for this special case. Applying the
rule in 2.2.3.2 I would get {1;0;1|#NV;#NV;#NV|#NV;#NV;#NV} because the second
operand hasn't got a second and third row, or applying the rule in 2.2.3.3 I
would get {1;#NV;#NV|0;#NV;#NV|1;#NV;#NV} because the first operand hasn't got a
second and third column. The spec should have an additional rule for this case
to make it unambiguous. The way Excel does it, generating a crosstabulation,
seems the way users expect.
In OOo you can get the same result as in Excel, if you use
=SUMPRODUCT(MMULT(($A$2:$A$4=$A$9);($B$1:$D$1=$A$10))*$B$2:$D$4). But
unfortunately Excel doesn't like this formula.
*** This issue has been marked as a duplicate of 46681 ***
-
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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 --- Additional comments from [EMAIL PROTECTED] Sat Aug 2 12:36:59 + 2008 --- Created an attachment (id=55506) Example for issue 92402 - 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 92402] SUMPRODUCT fails some calc ulations
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92402 Issue #|92402 Summary|SUMPRODUCT fails some calculations Component|Spreadsheet Version|OOo 2.4.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|vsoler --- Additional comments from [EMAIL PROTECTED] Sat Aug 2 12:29:55 + 2008 --- The SUMPRODUCT function in Excel is the most magical function I have come across. It can perform array-like calculations without forcing the formula with Crtl-Shift-Enter. A B C D 1 X Y X 2 a 1 6 3 3 b 3 4 1 4 a 5 8 2 In Excel, SUMPRODUCT((A2:A4="a")*(B1:D1="X")*B2:D4) yields 11 The same formula in Calc yields 1 There is no simple workaround for this problem, except setting up an Excel model different from the calc one. Could calc adapt to the behaviour of Excel? IMHO it's a must - 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]
