[sc-issues] [Issue 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from reg...@openoffice.org Tue Jan 6 10:47:54 + 2009 --- closing then - 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 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 --- Additional comments from ztevepow...@openoffice.org Tue Jan 6 09:19:06 + 2009 --- OK; I accept that this can be treated as a 'duplicate' of 65221. I will add a comment to 65221 to ensure that this extends to include this observation. - 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 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 User regina changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from reg...@openoffice.org Mon Jan 5 22:10:06 + 2009 --- Issue 65221 works as consolidation issue for handling of empty cells and empty strings. Therefore the decision "duplicate" seems right to me. Eike (er), who is the developer to solve this problem, will notice this duplicate and consider it. Setting to duplicate again. OOo is not free to define the behavior, because OOo wants to be ODF conform. Unfortunately the behavior of SUMIF is not yet defined completely. Especially the case, when the criteria range do not contain numbers and the criteria is a comparison with a text, is still in discussion. The single comparison A1<>"y" is right. It has to be calculated as NOT(A1="y") and the comparison = is FALSE, if the operands have different types, and an empty cell is not of type "text". *** This issue has been marked as a duplicate of 65221 *** - 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 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 User ztevepowell changed the following: What|Old value |New value Status|RESOLVED |UNCONFIRMED Resolution|DUPLICATE | --- Additional comments from ztevepow...@openoffice.org Mon Jan 5 15:47:37 + 2009 --- I do not think this is a dup of 65221 for two reasons: 1 65221 talks about equality and this talks of inequality (minor but non-trivial in three-value logic) 2 65221 talks about compatibility with XL, but this issue points out that CALC is inconsistent with itself. However 65221 is resolved, it would still be a good idea to be consistent with our own boolean evaluations (as the current issue points out). - 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 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 User dridgway changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from dridg...@openoffice.org Mon Jan 5 14:09:35 + 2009 --- Looks like a dupe, check out the testcases under issue 65221, and make sure that this one is covered there. *** This issue has been marked as a duplicate of 65221 *** - 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 97711] sumif criterion differs fr om cell formula
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97711 Issue #|97711 Summary|sumif criterion differs from cell formula Component|Spreadsheet Version|OOO300m9 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|ztevepowell --- Additional comments from ztevepow...@openoffice.org Fri Jan 2 20:05:45 + 2009 --- sumif(a1:a3;"<>y";b1:b3) produces 10 for the following input: A1 : A2 : n A3 : y B1 : 1 B2 : 10 B3 : 100 but the cells making individual tests are as follows: C1 : A1<>"y" displays TRUE C2 : A2<>"y" displays TRUE C3 : A3<>"y" displays FALSE we should get the answer '11' from the SUMIF formula, if the criteria behave the same, which they should. The treatment of cells is different, and this makes it hard to programme some SUMIF statements (this is different from the XL behaviour in this case, too). - 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