To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 Issue #|101712 Summary|Countif can't count text wildcards Component|Spreadsheet Version|OOo 3.0.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|mrmaceurope
------- Additional comments from mrmaceur...@openoffice.org Sat May 9 16:26:09 +0000 2009 ------- I have just imported a large Microsoft Excel file into OOO 3.0.1. The spreadsheet uses the COUNTIF function, but it didn't have be the same result as in Excel. Then I checked the formula and I found that OOO doesn't allow the use of wildcard when using CountIf. If you e.g. want to count Columns with more words (text) in each cell, the function fails. Please see my attached Calc file. --------------------------------------------------------------------- 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