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: mariob...@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.
