Issue 87106 - COUNTIF doesn't support wildcards needed for MS Excel compatibility
Summary: COUNTIF doesn't support wildcards needed for MS Excel compatibility
Status: CLOSED DUPLICATE of issue 32344
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.4 RC5
Hardware: All Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2008-03-17 03:37 UTC by ccheney
Modified: 2008-03-17 14:45 UTC (History)
1 user (show)

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

example file with issue (8.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-03-17 03:38 UTC, ccheney
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ccheney 2008-03-17 03:37:20 UTC
When opening an MS excel sheet with wildcards used in an IF statement the
Microsoft version recognises it and uses it in the calculation, but doesn't, with the result the value been set to 0. Here's an example:

In row 2 we've got a number of cells with codes in it, let's say B2...L2. In an
other cell there's the formula =(COUNTIF(B2:L2;"A")). When OpenOffice sees the V
in a cell in the list, the cell is counted as it should be. But when the formula
is modified with wildcards in it: =(COUNTIF(B2:L2;"*A*")) the V will not be
recognised in the cell, and MS Office sees every V listed in it, also when the
cell contains information like AW, the A will be regognised in a cell with the
formula =(COUNTIF(B2:L2;"*A*")) and the W will be regognised in an other cell
with =(COUNTIF(B2:L2;"*W*")) in it. This is very important that when a cell is
marked with both characters that they should be extracted to both formulas, so
the ASAP jobs (A) and the Waiting for new parts (W) will be calculated.

This bug also includes the =(COUNTIF(B2:L2;"?A?")) question mark method when a
cell always contains 3 characters and the middle character is being recognised
as an A. This will also result in miscalculation. BTW as far as i'm well
informed, the wildcards and question signs are undocumented features of MS Office.

An example sheet is attached.

To get OpenOffice more compatible with importing MS Office documents these
options should be implemented.
Comment 1 ccheney 2008-03-17 03:38:06 UTC
Created attachment 52142 [details]
example file with issue
Comment 2 ooo 2008-03-17 14:44:46 UTC
Simple wildcards not implemented.

*** This issue has been marked as a duplicate of 32344 ***
Comment 3 ooo 2008-03-17 14:45:29 UTC