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

COUNTA, AVERAGEA, xxxA.... Reword to have consistent treatment of text

    XMLWordPrintable

    Details

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

      AVERAGEA:

      Change Summary from
      Average the set of numbers, including logical values inside a range.
      to
      Average values, including values of type Text and Logical.

      Change Semantics to
      Behaves similarly to the AVERAGE function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. Any N may be of type ReferenceList.

      MAXA:

      Change Summary from
      Return the maximum from a set of numbers; logicals are always considered numbers.
      to
      Return the maximum from a set of values, including values of type Text and Logical.

      Change Semantics to
      Behaves similarly to the MAX function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MAXA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.

      MINA:

      Change Summary from
      Return the minimum from a set of numbers; logicals are always considered numbers.
      to
      Return the minimum from a set of values, including values of type Text and Logical.

      Change Semantics to
      Behaves similarly to the MIN function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MINA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList.

      STDEVA:

      Change Summary from
      Calculates the standard deviation using a sample set of numbers.
      to
      Calculate the standard deviation using a sample set of values, including values of type Text and Logical.

      Change Semantics from
      In the sequence, only numbers and logical types are considered; cells with text are converted to 0; other types are ignored. If logical types are a distinct type, they are still included, with True considered 1 and False considered 0.
      to
      Behaves similarly to the STDEV function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included.

      and
      The handling of strings is implementation defined. Either, strings are converted to numbers, if possible and otherwise, they are treated as zero, or strings are always treated as zero.
      to
      The handling of string constants as parameters is implementation-defined. Either, string constants are converted to numbers, if possible and otherwise, they are treated as zero, or string constants are always treated as zero.

      STDEVPA:

      Change Summary from
      Calculates the standard deviation using the population of a random variable.
      to
      Calculates the standard deviation using the population of a random variable, including values of type Text and Logical.

      Change Semantics same as in STDEVA.

      VARA:

      Change Summary from
      Estimates the variance using a sample set of numbers.
      to
      Estimates the variance using a sample set of values, including values of type Text and Logical.

      Change Semantics same as in STDEVA.

      VARPA:

      Change Summary from
      Calculates the variance using the population of the distribution
      to
      Calculates the variance using the population of the distribution, including values of type Text and Logical.

      Change Semantics same as in STDEVA.

      Show
      AVERAGEA: Change Summary from Average the set of numbers, including logical values inside a range. to Average values, including values of type Text and Logical. Change Semantics to Behaves similarly to the AVERAGE function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. Any N may be of type ReferenceList. MAXA: Change Summary from Return the maximum from a set of numbers; logicals are always considered numbers. to Return the maximum from a set of values, including values of type Text and Logical. Change Semantics to Behaves similarly to the MAX function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MAXA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList. MINA: Change Summary from Return the minimum from a set of numbers; logicals are always considered numbers. to Return the minimum from a set of values, including values of type Text and Logical. Change Semantics to Behaves similarly to the MIN function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. What happens when MINA is provided 0 parameters is implementation-defined. Any N may be of type ReferenceList. STDEVA: Change Summary from Calculates the standard deviation using a sample set of numbers. to Calculate the standard deviation using a sample set of values, including values of type Text and Logical. Change Semantics from In the sequence, only numbers and logical types are considered; cells with text are converted to 0; other types are ignored. If logical types are a distinct type, they are still included, with True considered 1 and False considered 0. to Behaves similarly to the STDEV function, but includes values of type Text and Logical. Text values are treated as number 0. Logical True is treated as 1, and False is treated as 0. Empty cells are not included. and The handling of strings is implementation defined. Either, strings are converted to numbers, if possible and otherwise, they are treated as zero, or strings are always treated as zero. to The handling of string constants as parameters is implementation-defined. Either, string constants are converted to numbers, if possible and otherwise, they are treated as zero, or string constants are always treated as zero. STDEVPA: Change Summary from Calculates the standard deviation using the population of a random variable. to Calculates the standard deviation using the population of a random variable, including values of type Text and Logical. Change Semantics same as in STDEVA. VARA: Change Summary from Estimates the variance using a sample set of numbers. to Estimates the variance using a sample set of values, including values of type Text and Logical. Change Semantics same as in STDEVA. VARPA: Change Summary from Calculates the variance using the population of the distribution to Calculates the variance using the population of the distribution, including values of type Text and Logical. Change Semantics same as in STDEVA.

      Description

      From http://tools.oasis-open.org/issues/browse/OFFICE-662

      COUNTA, AVERAGEA, xxxA....
      Reword these xxxA functions with consistency eg treatment of text

        Attachments

          Activity

            People

            • Assignee:
              erack Eike Rathke (Inactive)
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: