Issue 101712 - Countif can't count text wildcards
Summary: Countif can't count text wildcards
Status: CLOSED DUPLICATE of issue 32344
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2009-05-09 17:26 UTC by mrmaceurope
Modified: 2010-07-19 13:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Example to show the problem with COUNTIF with use of wildcards (10.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-09 17:27 UTC, mrmaceurope
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mrmaceurope 2009-05-09 17:26:09 UTC
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.
Comment 1 mrmaceurope 2009-05-09 17:27:24 UTC
Created attachment 62122 [details]
Example to show the problem with COUNTIF with use of wildcards
Comment 2 tomwb 2009-05-09 22:13:31 UTC
This link shows how wildcards work with countif.  Calc can use "Regular
Expressions", which are more robust than what Excel can do.

Comment 3 mrmaceurope 2009-05-10 00:04:25 UTC
Correct as stated by TomWb, to use wildcards with the COUNTIF function I need to
use Regular Expressions. But - this should then have been 'catch' by the Excel
Importer function, cause otherwise many people will see this as something OOO
can't handle which isn't true! 
Comment 4 ooo 2010-07-19 13:46:54 UTC
wildcard issue

*** This issue has been marked as a duplicate of 32344 ***
Comment 5 ooo 2010-07-19 13:47:28 UTC
Closing dup.