To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74606 Issue #|74606 Summary|COUNTIF(a1,"="&a1) sometimes returns 0 Component|Spreadsheet Version|OOo 2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|jcuadros
------- Additional comments from [EMAIL PROTECTED] Fri Feb 16 15:13:51 +0000 2007 ------- The formula COUNTIF(a1,"="&a1) returns an unexpected value of 0 (instead of 1) for some random numbers (for example, 0.1132236701559500000). This may lead to uncatchable errors when counting in ranges. The error has been duplicated in two different machines running Windows XP and with different version of OOo (2.0.4 and 2.1). The error is not reproduceable in Excel. --------------------------------------------------------------------- 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]