[OASIS Issue Tracker] Created: (OFFICE-2750) Needs-Discussion: 5.8:Error Literals in References

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: Improvement
          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