OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

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


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]