Issue 51072

Summary: COUNTIF should allow wildcards
Product: Calc Reporter: navvy <dave.wedd>
Component: codeAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0 Beta   
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description navvy 2005-06-21 21:20:24 UTC
Excel's version of COUNTIF supports wildcards * and ? in the criteria, but 
Calc doesn't. 

These wildcards have been in use since CP/M (before Microsoft!) and I can't 
see any reason for Open Office not to use them.

I use the criteria "??*" to count both "Op" and "Ins" because my instructors 
are also operators and I want a total of everyone who can operate.  I just 
want to count all the 2 and 3 letter words.  I don't want to use regular 
expressions.
Comment 1 frank 2005-06-30 12:14:31 UTC
This is a double to Issue 32344 .

*** This issue has been marked as a duplicate of 32344 ***
Comment 2 frank 2005-06-30 12:14:52 UTC
closed double