[sc-issues] [Issue 65221] SUMIF, COUNTIF, COUNTBLANK , DCOUNT, DSUM, ... with empty cells and "" an d ="" empty string criteria
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65221 --- Additional comments from ztevepow...@openoffice.org Tue Jan 6 09:36:59 + 2009 --- In the other issues consolidated here there is considerable confusion about what constitutes an empty cell and whether OOo should be 'compatible' with XL. There is a further issue: in the help it clearly uses the phrase 'empty cell' to mean one with no value set, and furthermore to DEFINE equality comparison with "" and 0 to succeed against such cells. Try, for example, using A1="" and A1<>"" as cell formulae against the empty (unset) cell A1, and you will discover the semantics of comparison. Independent of the question of compatibility with XL is the necessity for compatibility with OOo. SUMIF, COUNTIF and the like, should apply the same comparison rules as simple comparison formulae -- and they don't. This note is to request of the developer looking at this to provide some sort of specification, and to ensure that self-consistency is preserved. Is there a place to discuss this? - 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 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 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