To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110508 Issue #|110508 Summary|Function COUNTBLANK() not working as expected Component|Spreadsheet Version|OOO320m12 Platform|All URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|cjhansen
------- Additional comments from [email protected] Tue Mar 30 23:00:43 +0000 2010 ------- NOTE: This problem has been reported before, and closed by OC, without being fixed, perhaps because of a misunderstanding of the function’s use. The Excel function COUNTBLANK() is used to count cells whose RESULTS are blank, NOT only cells that are entirely empty. If cell A1 has the formula ="" (a null string), =Countblank(A1) should return 1 I use spreadsheets that have very complex formulae that return a null string if certain conditions are met. Other cells then test, using Countblank .. =IF (COUNTBLANK(A1)=1,Then, Else). Having this function work as intended is important. --------------------------------------------------------------------- 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]
