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

Explanation of SHEET incomplete.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 1
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Add to Semantics:
      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.

      Show
      Add to Semantics: 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.
    • Resolution:
      Hide

      Added to Semantics:
      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.

      Show
      Added to Semantics: 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.

      Description

      In the description of the SHEET function (6.12.30) it is not quite clear which arguments are evaluated. Since it acts on a reference, clearly SHEET([.B2]) gives the sheet number of the sheet containing cell [.B2] even if .B2 might contain a string that is the name of a sheet.

      What happens with constructions such as
      =sheet(concatenate("Sheet","1"))

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: