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.