Issue 113243

Summary:	Countif wildcard breaks compatibility with excel
Product:	Calc	Reporter:	jhbsa <johanh.botha>
Component:	code	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P4	CC:	issues
Version:	OOo 3.2.1
Target Milestone:	---
Hardware:	Other
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.