[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: HYPERLINK() function weirdness
Hi, If someone is assigned the specification of the HYPERLINK function, please note that it has some really weird "side effects", e.g. the formula =IF(FALSE();HYPERLINK("http://www.example.org/");"something") results in a hyperlink cell though the HYPERLINK function will not be evaluated. The cell contains the (not working) URL and the result “something”. Best is probably to follow the specification of http://specs.openoffice.org/calc/compatibility/HyperLinkFunction.sxw Eike -- Automatic string conversions considered dangerous. They are the GOTO statements of spreadsheets. --Robert Weir on the OpenDocument formula subcommittee's list.