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


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

Subject: [OASIS Issue Tracker] Commented: (OFFICE-2750) 5.8: Error Literalsin References

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

Dennis Hamilton commented on OFFICE-2750:



I agree, the recent discussion is over pattern  '[' "#REF!" ']'  versus '[' Error ']'. 

 I'm a proponent of the latter, which is closest to the original.  And you?

With regard to your observations about the use case, it seems to me that "=SUM([A1],[#REF!]) evaluates to an Error-type value, the same as it would if [A1] held an Error-type value. 

Where does does 5.12 deny there is not an Error value as a result of the reference?  If so, that should be fixed, because Error-type values do occur as the result of well-formed Reference evaluations ([A1] above), and the Reference syntax *as it exists* in CD05 allows Error-type values to be explicitly included in the Reference.  All we've done in this issue is change the form for that case (moving it to the entire reference and now discussing whether the specific Error-type value should be wired into the syntax or not.

So if it is not clear that the result of evaluation of a reference of form '[' Error ']' is an Error-type value, we need to say so.

Are you objecting to the change of syntax from CD05 to what Eike proposes or is there some other probem that we can't repair here by refining the proposal?

> 5.8: Error Literals in References
> ---------------------------------
>                 Key: OFFICE-2750
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2750
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Eric Patterson
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 CD 06
> When a part of a refence has been invalidated (ex. deleting a column) it is often useful to show an error literal as the part of the reference that was invalidated.  The reference syntax seems to indicate that a reference can be used in place of the sheetname, but the exact syntax doesn't seem clear.
> For example, if you have a formula that adds cell A1 and B2 and then delete column B, what will the resulting formula be?
> In Excel:
> Original formula =A1 + B1
> Resulting formula =A1 + #REF!
> In Calc:
> Original formula =A1 + B1
> Resulting formula =A1 + #REF!1

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


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