[Issue 125346] New: search

[bu...@apache.org]

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

          Issue ID: 125346
        Issue Type: DEFECT
           Summary: search
           Product: Calc
           Version: 4.1.0
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: marioboy1@hotmail.com

Created attachment 83769
  --> https://issues.apache.org/ooo/attachment.cgi?id=83769&action=edit
test file where I cant find values using searchv or count.if

I have am UTF-8 csv file.
I am performing a text search within a specific column.
If I use count.if(specific_colum;value_i_am-trying_to_find_in_Matrix) Opencalc
in some values just dont get the match and returns a mistaken result, having
that the value exists on specific column.

I validated using simple text search function CTRL-F and the value appears on
specific_column but even using count.if OR searchv it seams that opencalc just
cant find the matches.



I am attaching the file i am using and try to find sku 5S700LCD from column D
on specific_column B using count.if or searchv. It returns 0; but performing a
simple search with CTRL-F it finds both values on the matrix




I even deactivate from Options-calculate-use regular expressions on formulas
and still the same.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.

[Issue 125346] search

[bu...@apache.org]

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.