HYPERLINK() function weirdness

[Eike Rathke <erack@sun.com>]

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.