[OASIS Issue Tracker] Commented: (OFFICE-3435) ODF 1.2 CD05 Part 26.11.13 Incredible HYPERLINK Function

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-3435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23024#action_23024 ] 

Dennis Hamilton commented on OFFICE-3435:
-----------------------------------------

@Rob I don't see how we can reasonably talk about a function that influences what a cell's styling as a hyperlink might be.  In fact, the need to speak of the cell in the definition of this function is really odd, since there is no requirement even that this be the "outer" expression.

Defining it as simply returning one argument or another and not defining the side-effect seems completely odd, although it gets around how inappropriate the side-effect is.

It can be better defined than that, if we are insistent on keeping it, and I find it amusing that there is already disturbance on what it means to make a cell a hyperlink cell when ODF 1.2 has no such explicit attribute or other way to convey that consequence and my example of a paragraph with <text:a> aroused so much agitation about what that has to mean.

@Andreas
I consider that the <text:a> example as a way of expressing the hyperlink without recalculation (or even knowing the formula system being used) is quite an appropriate solution, just as is type-inference of cell value types from a formula and also something like this:

 <table:table-cell 
       table:style="some formatting requirement"
       table:formula="=PI()*1E10" 
       office:value-type="double" 
       office:value="3.1415926535897932384626433832795E10" 
       > 
   <text:p>31,415,926,536</text:p> 
</table:table-cell> 

I neglected to put a style in the HYPERLINK example, but surely there would be one that did not show any different typography (no blue underlining, say) but was still "active" as a hyperlink.  I'll not worry about the nuances around a hyperlink on a cell that is given an empty string as its value.

There is a separation of concerns that is important to deal with here.

> ODF 1.2 CD05 Part 2 6.11.13 Incredible HYPERLINK Function 
> ----------------------------------------------------------
>
>                 Key: OFFICE-3435
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3435
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: Needs Discussion, OpenFormula, Part 2 (Formulas)
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Dennis Hamilton
>            Assignee: Dennis Hamilton
>             Fix For: ODF 1.2 CD 06
>
>
> ODF 1.2 CD05 Part 2 has an inexplicable definition for the HYPERLINK function.
> The description asserts that there is an effect on a cell.
> The description assrts that there is an effect on a cell even if the function's occurrence is not needed in the evaluation of the formula.
> The description asserts that there is a coordinated effect in how an IRI is composed (or multiples delivered) from individual occurrences of the HYPERLINK function in the same expression.
> The description asserts unjustifiable requirements on the implementation of an evaluator.
> Finally, the examples of this function are used to refine the definition.  Only the simplest examples can be inferred from the definition.
> It appears that incidental consequences of a specific implementation are being appealed to, without concern for what is essential and good enough for an OpenFormula case and no matter what odd behaviors that implementations might have for cases that defy well-definedness.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira