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

3.10.9 Criteria - incoherent use of the term criteria

    XMLWordPrintable

    Details

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

      A criteria is a rectangular set of values, with at least one column and two rows, that selects matching records from a database. The first row lists fields against which expressions will be matched. 3.10.8 The following rows contain fields with expressions for matching against database records.

      For a record to be selected from a database, all of the expressions in a row of expressions shall match.

      (Possibly insert language on reference to empty cell if that isn't already covered by reference.)

      A matching expression can be:

      Show
      A criteria is a rectangular set of values, with at least one column and two rows, that selects matching records from a database. The first row lists fields against which expressions will be matched. 3.10.8 The following rows contain fields with expressions for matching against database records. For a record to be selected from a database, all of the expressions in a row of expressions shall match. (Possibly insert language on reference to empty cell if that isn't already covered by reference.) A matching expression can be:
    • Resolution:
      Hide

      This and the changes of OFFICE-1194 will fix that.

      Show
      This and the changes of OFFICE-1194 will fix that.

      Description

      We say:

      ****
      A criteria is a set of selectors that select records from a database. A criteria is a rectangular set of values, with at least one column and at least two rows. The first row lists the fields that are to be considered. 3.10.8 The rest of the rows list criteriasets.

      For a record to be selected from a database, all of the requirements of at least one row of criteriasets shall match. Inside each criteriasets are zero or more criteria.

      Criteria can be one of the following: (number or logical value for instance, in contrast to the first paragraph where it is said to have at least one column and at least two rows)
      ****

      Note that "criteria C" occurs all over the place. If it is supposed to be bound to this section, delete explanations elsewhere and write this properly.

      Question: Do we need to say that "A reference to an empty cell is interpreted as the numeric value 0." here?

      I ask because we inconsistently say that elsewhere when we redundantly talk about criteria C:

      **
      5.13.9 COUNTIF, 5.13.10 COUNTIFS,
      The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
      5.16.62 SUMIF
      The criteria C may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria.
      5.16.63 SUMIFS
      The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
      5.18.5 AVERAGEIF, 5.18.6 AVERAGEIFS
      The criteria may be a number, an expression, or a text string. A text string starting with a comparison operator is interpreted as a comparison criteria. A reference to an empty cell is interpreted as the numeric value 0.
      **
      Note that SUMIF is the odd-man out. No reference to what happens for no match.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: