To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 Issue #|99472 Summary|VLookup breaks if a PIPE '|' character is used in matc |hing character fields Component|Spreadsheet Version|OOo 3.0.1 Platform|Macintosh URL|http://i39.tinypic.com/2m6mvsj.png OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|er1cpeters
------- Additional comments from er1cpet...@openoffice.org Fri Feb 20 19:16:31 +0000 2009 ------- 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 :) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org