Issue 113243 - Countif wildcard breaks compatibility with excel
Summary: Countif wildcard breaks compatibility with excel
Status: CLOSED DUPLICATE of issue 32344
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.2.1
Hardware: Other Linux, all
: P4 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2010-07-19 13:19 UTC by jhbsa
Modified: 2010-07-19 13:50 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description jhbsa 2010-07-19 13:19:34 UTC
I have a spreadsheet that was created in Excel,
When I open it in OpenOffice, the summary report is wrong, because they used
countif with a with a wildcard ( "SUCCESS*").
Excel counts all fields starting with SUCCESS, whereas OpenOffice want an exact
The result is that the value used for further calculations are wrong.
Comment 1 ooo 2010-07-19 13:49:58 UTC
Please search for issues before reporting.

*** This issue has been marked as a duplicate of 32344 ***
Comment 2 ooo 2010-07-19 13:50:23 UTC
Closing dup.