Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2750

5.8: Error Literals in References

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      In 5.8 References remove Error and add ReferenceError to EBNF.
      Replace
      "
      Reference ::= '[' Source? RangeAddress ']'
      "
      with
      "
      Reference ::= '[' (Source? RangeAddress) | ReferenceError ']'
      "

      Replace
      "
      QuotedSheetName ::= '$'? SingleQuoted | Error
      "
      with
      "
      QuotedSheetName ::= '$'? SingleQuoted
      "

      Add definition
      "
      ReferenceError ::= "#REF!"
      "

      Add to text:
      A ReferenceError provides information that a formula evaluates to an Error because of a particular reference having been invalidated by actions that occurred after the formula was validly created.

      Show
      In 5.8 References remove Error and add ReferenceError to EBNF. Replace " Reference ::= ' [' Source? RangeAddress '] ' " with " Reference ::= ' [' (Source? RangeAddress) | ReferenceError '] ' " Replace " QuotedSheetName ::= '$'? SingleQuoted | Error " with " QuotedSheetName ::= '$'? SingleQuoted " Add definition " ReferenceError ::= "#REF!" " Add to text: A ReferenceError provides information that a formula evaluates to an Error because of a particular reference having been invalidated by actions that occurred after the formula was validly created.

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: