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) Needs-Discussion:5.8: Error Literals in References

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

Eike Rathke commented on OFFICE-2750:

The original display format in Calc was chosen to give the user a hint what may have caused the invalid reference.
For a reference Sheet1.A1 if
Sheet deleted: #REF!.A1
Column deleted: Sheet1.#REF!1
Row deleted: Sheet1.A#REF!
That doesn't play well with the current OpenFormula definition.

Questions are, do we want to preserve that detailed information, or do we lump all together in one #REF!, and if so, with or without brackets, and with or without a leading '.' dot as a sheet name separator if no sheet was given?

I propose to keep at least the surrounding brackets for easy identification, all references are enclosed in brackets. [#REF!] looks viable to me.

Current definition also says
QuotedSheetName ::= '$'? SingleQuoted | Error
implicating Error could be any error constant, that certainly is not the case.

> Needs-Discussion: 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
> 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]