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

CLONE - Missing zero population size error cases in some OpenFormula statistical function definitions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: New
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.2 Errata 01
    • Component/s: OpenFormula
    • Labels:
      None
    • Environment:

      N/A

    • Proposal:
      Hide

      Add a constraint to each of the affected functions, reading:

      STDEVP exchange "Constraints: None." with "Constraints: COUNT(N) >= 1."
      STDEVPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."
      VARPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."

      Show
      Add a constraint to each of the affected functions, reading: STDEVP exchange "Constraints: None." with "Constraints: COUNT(N) >= 1." STDEVPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1." VARPA exchange "Constraints: None." with "Constraints: COUNTA(sample) >= 1."

      Description

      I've been doing some research on missing spreadsheet function constraints, and I noticed that, in a couple of the OpenFormula statistical functions, there should be a constraint requiring population size to be greater than zero. All the existing implementations I tested already return an error in this instance, but it probably ought to be added to OpenFormula.

      The functions affected are:

      STDEVP (ODF 1.2 Part 2, 6.18.74)
      STDEVPA (6.18.75)
      VARPA (6.18.85)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              chris.rae Chris Rae (Inactive)
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: