To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104952
------- Additional comments from jeff...@openoffice.org Tue Jul 20 06:07:04 +0000 2010 ------- To keep hyperlink, bypass is to test MATCH function returns an #NA error =IF(ISNA(MATCH(B1;A1:A1;0);"";HYPERLINK("#Sheet1.A"&MATCH(B1;A1:A1;0)) Best regards --------------------------------------------------------------------- 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