[OASIS Issue Tracker] Created: (OFFICE-2285) Incorrect COVARconstraint

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

Incorrect COVAR constraint
--------------------------

                 Key: OFFICE-2285
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2285
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
    Affects Versions: ODF 1.2
            Reporter: Andreas Guelzow 
             Fix For: ODF 1.2


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.  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira