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

4.10.5 Automatic Range - corresponding/respectively?

    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 4.10.5 Automatic Range
      Replace
      "
      When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, a column or row label is converted to an automatic range reference that is adjusted each time the formula is interpreted. The range is generated from the corresponding column respectively row intersecting an area directly below respectively right of the label cell that is constructed by encompassing contiguous cells. A blank cell interrupts contiguousness, one blank cell directly below respectively right of the label cell is ignored.
      "
      with
      "
      When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, an automatically looked up column or row label (not defined label range) is converted to an automatic range reference that is adjusted each time the formula is interpreted. The range is generated from the column below a column label, or the row right of a row label, constructed by encompassing contiguous non-empty cells. An empty cell interrupts contiguousness, one empty cell directly below a column label cell or right of a row label cell is ignored.
      "

      In the Comments column of the examples replace all "blank cell" with "empty cell".

      To 4.10.3 Automatic Lookup of Labels add
      Note: Document authors should be aware that using automatically looked up column or row labels in expressions impairs interoperability.

      Amended note to read: Note: Use of automatically looked up column or row labels in expressions impairs interoperability.

      Show
      In 4.10.5 Automatic Range Replace " When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, a column or row label is converted to an automatic range reference that is adjusted each time the formula is interpreted. The range is generated from the corresponding column respectively row intersecting an area directly below respectively right of the label cell that is constructed by encompassing contiguous cells. A blank cell interrupts contiguousness, one blank cell directly below respectively right of the label cell is ignored. " with " When passed as a non-scalar argument (e.g. Array or NumberSequence) to a function, an automatically looked up column or row label (not defined label range) is converted to an automatic range reference that is adjusted each time the formula is interpreted. The range is generated from the column below a column label, or the row right of a row label, constructed by encompassing contiguous non-empty cells. An empty cell interrupts contiguousness, one empty cell directly below a column label cell or right of a row label cell is ignored. " In the Comments column of the examples replace all "blank cell" with "empty cell". To 4.10.3 Automatic Lookup of Labels add Note: Document authors should be aware that using automatically looked up column or row labels in expressions impairs interoperability. Amended note to read: Note: Use of automatically looked up column or row labels in expressions impairs interoperability.

      Description

      Under 4.10.5 we say:

      "The range is generated from the corresponding column respectively row intersecting an area directly below respectively right of the label cell that is constructed by encompassing contiguous cells. A blank cell interrupts contiguousness, one blank cell directly below respectively right of the label cell is ignored."

      Four questions:

      1) Is the intent of this statement that a contiguous range of cells is selected and as each value for a column/row is passed, the column/row label attaches to the next cell in line. Yes?

      2) What happens if there is a blank cell that interrupts contiguousness?

      3) Can anyone suggest a re-writing of this that doesn't use "corresponding" and "respectively"?

      4) Looking at the examples, how does the blank cell in row 2 qualify as "one black cell below respectively right of the label cell"? I am assuming that row 1, column Data is the label cell.

      Do we need these examples? For that matter are they consistent with the text?

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: