ODF 1.2 CD05 Part 2 6.11.13 Incredible HYPERLINK Function

[Dennis]

OPTION 1. (The painless approach.) Delete the HYPERLINK function from ODF 1.2 Part 2.

OPTION 2. Replace the definition with one that works without assumptions about how cells support hyperlinks and that provides a rational evaluation rule.

2.1 Eliminate the idiosyncratic behavior that is discovered about a particular implementation's behavior.

2.2 Provide assurance about some basic case and leave issues about occurences in non-evaluated parts of expressions, multiple uses of the function in a single expression, etc., undefined or implementation-dependent and give up.

2.3 Eliminate any observation about implementations and how a host accepts or does not accept an IRI as a companion result to an evaluation. Whether the IRI is ignored or not is a matter for host-dependent behavior, the only way it is known that the formula has anything to do with providing a value for a cell.

2.4 Also, both the IRI parameter and the value text should work with arbitrary expressions that determine their result. To use HYPERLINK cleanly, there should be no need for wacky side-effects from one occurrence of HYPERLINK to another in the same expression and everything should be well-definable.

2.5 The occurrence of this function in the interior of a named formula and in array expressions should be particularly exciting, and extensions to lists and matrix operations should be a hoot. There is probably something that needs to be checked-into and said about this.

2.6 The IRI delivered by the function (from whichever parameter) should be a well-formed IRI with the proviso that resolution of relative IRIs (including determination of the base IRI), limitations to particular IRI schemes, and IRI scheme-related limitations are host-dependent behaviors.

• or -

[Eike]
Keep as is.

Replace Section 6.11.3 HYPERLINK as follows

"""
Summary: Influence creation of a hyperlink involving the evaluated expression

Syntax: HYPERLINK(Text IRI [; Text|Number FunctionResult ] )

Returns: Text or Number

Constraints: None

Semantics: The default for the second argument is the value of the first argument. The second argument value is returned.

In addition, hosting environments may interpret expressions containing HYPERLINK function calls as calling for an implementation-dependent creation of a hypertext link based on the expression containing the HYPERLINK function calls.
"""