You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/12/21 22:55:59 UTC

[Bug 104952] Error Match function with Hyperlink function break link

https://issues.apache.org/ooo/show_bug.cgi?id=104952

--- Comment #4 from jeffooo <je...@orange.fr> ---
oouuppss, there is an error of parenthesis in formula.

The good formula for workaround is :

=IF(ISNA(MATCH(B1;A1:A1;0));"";HYPERLINK("#Sheet1.A"&MATCH(B1;A1:A1;0)))

-- 
You are receiving this mail because:
You are on the CC list for the bug.