Bug 146657 - COUNTIF mismatches Text
Summary: COUNTIF mismatches Text
Status: RESOLVED DUPLICATE of bug 139612
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
Depends on:
Reported: 2022-01-08 19:04 UTC by hailholyqueen
Modified: 2022-01-09 05:37 UTC (History)
0 users

See Also:
Crash report or crash signature:

Screenshot from the bug within Calc. (4.34 KB, image/png)
2022-01-08 19:04 UTC, hailholyqueen

Note You need to log in before you can comment on or make changes to this bug.
Description hailholyqueen 2022-01-08 19:04:53 UTC
Created attachment 177401 [details]
Screenshot from the bug within Calc.

Dear developers,

I found this bug in the German version of LibreOffice Calc, but I presume it will be the same in any other translation.

Try this in Calc:

Format A1 and A2 as text.
Enter in A1: 5
Enter in A2: 5+
(i.e. necessary when entering school grades in Germany)

Enter in A3: =ZÄHLENWENN(A1:A2;"5")   means: =COUNTIF(...)

The result will be: "2". The "+" in A2 is not being noticed by the program. When you open the file in MS Excel, the correct result "1" is displayed. 

Thank you for your great work, you are creating a fabulous program!

Yours sincerely
Comment 1 Mike Kaganski 2022-01-09 05:37:08 UTC
Generally COUNTIF depends on what is selected at Options->LibreOffice->Calculate, General Calculations/Search criteria = and <> must apply to whole cells. However, until recently, there was bug 139612, fixed in 7.2.5.

*** This bug has been marked as a duplicate of bug 139612 ***