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

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2 CD 06
    • Affects Version/s: ODF 1.2 CD 05
    • Component/s: OpenFormula
    • None
    • 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.

      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.

            Assignee:
            Patrick Durusau
            Reporter:
            Eric Patterson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: