OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: HYPERLINK() function weirdness


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

Best is probably to follow the specification of


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]