Issue 46706 - Countif function does not support wildcards as in Excel
Summary: Countif function does not support wildcards as in Excel
Status: CLOSED DUPLICATE of issue 32344
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-04-05 13:07 UTC by ibaines
Modified: 2005-04-05 14:01 UTC (History)
1 user (show)

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

Attachments
Test to demonstrate COUNTIF wildcard failure on Openoffice (14.00 KB, application/vnd.ms-excel)
2005-04-05 13:10 UTC, ibaines 		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 ibaines 2005-04-05 13:07:35 UTC 
In Excel, it is possible to use COUNTIF to count occurrences of characters or
strings within a larger set using wildcards, with either ? or * used to match
single or multiple wild characters e.g:-

COUNTIF(<range>;"*A*") will count all occurrences of character 'A' within range
of one or many characters.

Openoffice spreadsheet does not do this.

See help in Excel and search for "Wildcard"
Comment 1 ibaines 2005-04-05 13:10:26 UTC 
Created attachment 24685 [details]
Test to demonstrate COUNTIF wildcard failure on Openoffice
Comment 2 frank 2005-04-05 14:00:42 UTC 
Hi,

not a bug. For such things OOo has regular expressions. Have a look at he help
system for that.

Nevertheless this is a double to Issue 32344

Frank

*** This issue has been marked as a duplicate of 32344 ***
Comment 3 frank 2005-04-05 14:01:02 UTC 
closed double