You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/08/03 22:08:01 UTC

[Issue 125346] search

https://issues.apache.org/ooo/show_bug.cgi?id=125346

j.nitschke@ok.de changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |j.nitschke@ok.de
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #1 from j.nitschke@ok.de ---
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.