Issue 101712

Summary:

Countif can't count text wildcards

Product:

Calc

Reporter:

mrmaceurope <mrmaceurope>

Component:

code

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

OOo 3.0.1

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Example to show the problem with COUNTIF with use of wildcards	none

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.