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] (OFFICE-3856) Missing zero population size error cases in some OpenFormula statistical function definitions


     [ https://tools.oasis-open.org/issues/browse/OFFICE-3856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Weir  updated OFFICE-3856:
---------------------------------

    Proposal: 
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."


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

Constraints: Used sample size must be greater than zero.


> Missing zero population size error cases in some OpenFormula statistical function definitions
> ---------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-3856
>                 URL: https://tools.oasis-open.org/issues/browse/OFFICE-3856
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>         Environment: N/A
>            Reporter: Chris Rae
>            Priority: Minor
>             Fix For: ODF 1.2 Errata 01, ODF 1.3
>
>
> 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)



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)


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