Details

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

      Description

      COVAR has the constraint

      Constraints: Each sequence must contain 1 number at least. The number of numbers in n1 and
      n2 must be equal.

      Now suppose A1 to A4 contains 1;2;3;4
      and B1 to B4 contains 1;2;x;4 then according to the constraint COVAR (.A1:.A4;.B1:.B4) should be an error, but in OOo and Gnumeric it returns 1.55555556. (basically OOo and Gnumeric seem to drop the incomplete records, ie. it drops the values in A3 and B3.)

      Are we truly intending to use a definition contrary to the common implementations in place? Note that OOo and GNumeric's behaviour is much more reasonable.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: