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)
Version:
(earliest affected)
7.1.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
Screenshot from the bug within Calc. (4.34 KB, image/png)
2022-01-08 19:04 UTC, hailholyqueen 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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
Overlord
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 ***