To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=65221 Issue #:|65221 Summary:|SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... wiith |empty cells and "" and ="" empty string criteria Component:|Spreadsheet Version:|current Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|TASK Priority:|P3 Subcomponent:|code Assigned to:|er Reported by:|er
------- Additional comments from [EMAIL PROTECTED] Tue May 9 08:49:13 -0700 2006 ------- This is a consolidation issue of several other issues such as issue 13702, issue 50331 and issue 65109. Calc interprets criteria arguments to the SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... functions different from Excel if the criteria is a literal "" empty string, or a reference to a formula cell returning an empty string. Furthermore, Excel is not even consistent in how it handles these different forms, nor how it interprets the same form in different functions like DCOUNT and DSUM, and maybe other D*() functions. This is a mess. See attached testcase document. Load in both, Calc and Excel, to have a better comparison of the results and the colored TRUE/FALSE cells. We need to come to a conclusion how we'll handle this. Simply mimicking the Excel behavior may be appealing but might not be the best idea. --------------------------------------------------------------------- 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]
