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
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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.

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTIF_function

TomW
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.