Issue 99472 - VLookup breaks if a PIPE '|' character is used in matching character fields
Summary: VLookup breaks if a PIPE '|' character is used in matching character fields
Status: CLOSED DUPLICATE of issue 16786
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: Mac Mac OS X, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL: http://i39.tinypic.com/2m6mvsj.png
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-20 19:16 UTC by er1cpeters
Modified: 2010-09-28 15:42 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Example calc spreadsheet with the PIPE bug (8.03 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-02-20 19:17 UTC, er1cpeters 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description er1cpeters 2009-02-20 19:16:31 UTC 
See screenshot for an example.  Basically if the matching text has a "|" character the result returns N/A.  I 
use this all the time in Excel and PIPE is a great delimiter for creating surrogate keys for VLOOKUPs :)
Comment 1 er1cpeters 2009-02-20 19:17:31 UTC 
Created attachment 60338 [details]
Example calc spreadsheet with the PIPE bug
Comment 2 dzurn 2009-05-20 20:32:39 UTC 
VLOOKUP also fails to find any entries with either a single parenthesis "(" or a
pair of parentheses "(dfdfd)" anywhere in the matching character fields.
Comment 3 dzurn 2009-05-20 20:58:36 UTC 
I just found that the underlying cause is the same as 
http://qa.openoffice.org/issues/show_bug.cgi?id=44295

If "Regular Expressions in formulas" preference is turned off, then the example
spreadsheet works as expected, and parentheses are found as well.

It would still be nice to find a workaround in case other formulas do need
regular expressions.
Comment 4 niklas.nebel 2010-09-28 15:42:29 UTC 
Yes, it's the same as issue 44295, which is a duplicate of 16786.

*** This issue has been marked as a duplicate of 16786 ***
Comment 5 niklas.nebel 2010-09-28 15:42:58 UTC 
closing duplicate