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-3340

SHEET function with no parameter undefined when experession is used outside table cell

    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

      Update Last sentence of 6.13.31 as follows:
      6.13.31 SHEET
      Summary: Returns the sheet number of the reference or the string representing a sheet name.
      Syntax: SHEET( [ Text|Reference R ] )
      Returns: Number >= 1
      Constraints: R shall not contain a Source Location (5.8 References)
      Semantics: Returns the 1 based sheet number of the given reference or sheet name.
      Hidden sheets are not excluded from the sheet count.
      If no parameter is given, the result is the sheet number of the sheet containing the formula.
      If a Reference is given it is not dereferenced.
      If the reference encompasses more than one sheet, the result is the number of the first sheet in the range.
      If a reference does not contain a sheet reference, the result is the sheet number of the sheet containing the formula.
      anchor:SHEET
      If the function is not evaluated within a table cell, an error is returned.

      Show
      Update Last sentence of 6.13.31 as follows: 6.13.31 SHEET Summary: Returns the sheet number of the reference or the string representing a sheet name. Syntax: SHEET( [ Text|Reference R ] ) Returns: Number >= 1 Constraints: R shall not contain a Source Location (5.8 References) Semantics: Returns the 1 based sheet number of the given reference or sheet name. Hidden sheets are not excluded from the sheet count. If no parameter is given, the result is the sheet number of the sheet containing the formula. If a Reference is given it is not dereferenced. If the reference encompasses more than one sheet, the result is the number of the first sheet in the range. If a reference does not contain a sheet reference, the result is the sheet number of the sheet containing the formula. anchor:SHEET If the function is not evaluated within a table cell, an error is returned.

      Description

      If a named-expression is defined to use the expression "=SHEET()", the result is currently undefined in the specification given that the formula does not exist in a sheet.

        Attachments

          Activity

            People

            • Assignee:
              Patrick Patrick Durusau
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: