[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]