[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 rockf...@openoffice.org Wed Apr 7 20:42:42 + 2010 --- This defect is a major PITA. Compatibility with Excel aside, this is a MAJOR problem. Because of the way that OOo calculates empty cells with these functions, AFAIK there is NO WAY to accurately calculate the number of empty cells within a range if any of those cells contain an equation whose output is an empty string, i.e. ="". In Excel, this can be done one of TWO ways, using either COUNTBLANK(), or COUNTIF(,""). I started using COUNTBLANK originally so that spreadsheets which have to count blank/empty cells would be compatible with both Excel and OOo, since COUNTIF(,"") doesn't work at all in OOo. Now with more advanced spreadsheets which contain equations within these cell ranges, I've found that OOo is simply incapable of handling such simple equations, and I have been unable to find a way to make a spreadsheet that will calculate blank/empty cells correctly in OOo. So you see it is not simply a matter of OOo being incompatible with Excel; rather, it is a matter of OOo being absolutely incapable of performing such a (simple) calculation with its current function set. It is IMPOSSIBLE to count the number of blank cells (cells containing an empty string result ="" in addition to the truly empty cells containing absolutely nothing) using OOo. I've tried this in OOo 3.0 and 3.1, and there is NO WAY to do this as far as I can tell. If there is, please enlighten me. The earliest defect I found regarding this issue dates back to 2003. 7 years later it has yet to be addressed. COUNTIF(,"") doesn't work at all in OOo and always returns a result of 0. COUNTBLANK() will only count cells if they have absolutely nothing in them. IMO COUNTBLANK() should also count cells where an equation returns an empty string "". In fact, it is what I would expect given the fact that by returning an empty string, you are effectively saying "This cell is empty." ISBLANK() returns FALSE for a cell containing the equation ="". I read the Help manual and understand this is the expected behavior of OOo due to the way it specifies 'blank' cells, but WHY? I'd like to know what exactly the usage case is for counting cells containing equations that return an empty string "" as NOT blank? The current behavior and specification does not make any sense whatsoever IMO. There needs to be some simple way to do this. Using a function that is already shared by Excel and OOo would be ideal, because most people use Excel and not OOo. Also, the behavior of Excel for COUNTBLANK() makes far more sense than OOo's behavior. - 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 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 cjhan...@openoffice.org Wed Mar 31 15:49:31 + 2010 --- For those of us who develop spreadsheet applications for anonymous users, compatibility is a huge concern, even if the solution is not technically perfect. - 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 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 User brinzing changed the following: What|Old value |New value CC|'kohei,masayan,mathieupare|'brinzing,kohei,masayan,ma |nt,nn,regina' |thieuparent,nn,regina' --- Additional comments from brinz...@openoffice.org Wed Mar 31 09:15:33 + 2010 --- , - 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 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 reg...@openoffice.org Tue Mar 30 23:53:15 + 2010 --- *** Issue 110508 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 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 reg...@openoffice.org Wed Oct 14 19:52:48 + 2009 --- *** Issue 105908 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 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 User regina changed the following: What|Old value |New value CC|'kohei,masayan,mathieupare|'kohei,masayan,mathieupare |nt,nn'|nt,nn,regina' --- Additional comments from reg...@openoffice.org Tue Jan 6 10:45:11 + 2009 --- @ztevepowell: You can get the draft spec of ODF from http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula. You get most of the relevant places by searching for "empty cell" and "blank". A place to discuss the problem is the mailing list us...@sc.openoffice.org or maybe d...@sc.openoffice.org. - 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 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 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 reg...@openoffice.org Mon Jan 5 22:10:04 + 2009 --- *** Issue 97711 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 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 dridg...@openoffice.org Mon Jan 5 14:09:34 + 2009 --- *** Issue 97711 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 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 [EMAIL PROTECTED] Fri Feb 8 17:56:40 + 2008 --- *** Issue 85966 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: [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 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 User kohei changed the following: What|Old value |New value CC|'masayan,mathieuparent,nn'|'kohei,masayan,mathieupare | |nt,nn' - 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 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 [EMAIL PROTECTED] Mon Sep 3 12:14:41 + 2007 --- *** Issue 81198 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: [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 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 User masayan changed the following: What|Old value |New value CC|'mathieuparent,nn'|'masayan,mathieuparent,nn' - 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]