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

Attachments
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 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
match.
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.