https://issues.apache.org/ooo/show_bug.cgi?id=125346
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOT_AN_ISSUE --- Comment #1 from [email protected] --- COUNTIF compares the whole cell with your value, in your example two cells with 5S700LCD have a trailing space character. "5S700LCD" is not "5S700LCD " so it's not counted to count cells with leading or trailing spaces your criteria should look like this "[:space:]*value[:space:]*" btw if you use ctrl+F and select match only whole cells you will find the same results as countif ->not an issue -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
