[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=22777#action_22777 ] 

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

I think the explorations from Andreas demonstrate how wacky this "feature" is.  Worse, the wackiness is both overlapping and different between OOXM and OpenFormula.  So, if we could find a rigorous definition, it is not clear that it would do much for those who use the OpenOffice implementation and anyone who uses an Excel or OOXML implementation, so it is rather likely that we would encounter COM.MICROSOFT.HYPERLINK and ORG.OPENOFFICE.HYPERLINK anyhow.  (It is unfortunate there is no way to refer to functions defined in standards or under namespaces defined by standards, unless we fake  ORG.ISO.IS29500_2006.HYPERLINK.)

I find this to be great amunition for Option #1.  Option #3 (do nothing) would be irresponsible for me.

Here are the promised examples for Option #2.  I am using binding of an Evaluator into ODF 1.2 just for purposes of illustration and as a way to make my questions concrete.  

 

 =HYPERLINK("mailto:dennis.hamilton@acm.org";; "orcmid")
   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

In an integration of OpenFormula with an ODF 1.2 implementation, is this an appropriate persisted value of an element in a Conforming OpenDocument Document:

 <table:table-cell
       table:formula="=HYPERLINK(&quot;mailto:dennis.hamilton@acm.org&quot;; &quot;orcmid&quot;)"
       office:value-type="string"
       office:string-value="orcmid"
       >
   <text:p><text:a xlink:href="mailto:dennis.hamilton@acm.org";>orcmid</text:a></text:p>
</table:table-cell>
      
This is the essential question.  I will have a few more examples.       




> 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