Issue 44295 - Vlookup with "/" character
Summary: Vlookup with "/" character
Status: CLOSED DUPLICATE of issue 16786
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0 Beta
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-07 08:02 UTC by iansnz
Modified: 2010-09-28 15:41 UTC (History)
1 user (show)

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

Attachments
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 iansnz 2005-03-07 08:02:18 UTC 
When using vlookup to lookup a string value containing "/" the returned value is
incorrect. It would be correct if the string did NOT contain "/" .
eg when looking up the value "asdf/asdf" then "asdfasdf" is seen as the correct
return value.
Comment 1 frank 2005-03-24 13:04:33 UTC 
Hi,

not a bug.

/ is a placeholder for regular expressions. By default regular expressions are
enabled for functions. You can switch it off under tools options spreadsheet.

Frank
Comment 2 frank 2005-03-24 13:04:58 UTC 
closed invalid
Comment 3 ccheney 2009-02-04 21:31:17 UTC 
This should be made much more obvious to users or somehow disable regex
processing for regex characters when they are in text cells.
Comment 4 ccheney 2009-02-04 21:34:03 UTC 
Note it is not just / that triggers this, (, ) and + characters all trigger it.
It appears that you don't need a proper regex to trigger this issue, just any
character that happens to be in the regex grammar.
Comment 5 niklas.nebel 2010-09-28 15:40:42 UTC 
Same as issue 16786.

*** This issue has been marked as a duplicate of 16786 ***
Comment 6 niklas.nebel 2010-09-28 15:41:11 UTC 
closing duplicate