[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 User nn changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |DUPLICATE --- Additional comments from n...@openoffice.org Tue Sep 28 14:42:29 + 2010 --- Yes, it's the same as issue 44295, which is a duplicate of 16786. *** This issue has been marked as a duplicate of 16786 *** - 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 User nn changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from n...@openoffice.org Tue Sep 28 14:42:58 + 2010 --- closing duplicate - 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 --- Additional comments from dz...@openoffice.org Wed May 20 19:32:39 + 2009 --- VLOOKUP also fails to find any entries with either a single parenthesis ( or a pair of parentheses (dfdfd) anywhere in the matching character fields. - 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 User dzurn changed the following: What|Old value |New value CC|''|'dzurn' - 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 --- Additional comments from dz...@openoffice.org Wed May 20 19:58:36 + 2009 --- 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. - 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
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 + 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
[sc-issues] [Issue 99472] VLookup breaks if a PIPE ' |' character is used in matching character fie lds
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99472 --- Additional comments from er1cpet...@openoffice.org Fri Feb 20 19:17:31 + 2009 --- Created an attachment (id=60338) Example calc spreadsheet with the PIPE bug - 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
