[OASIS Issue Tracker] (OFFICE-3856) Missing zero population size error cases in some OpenFormula statistical function definitions

From
OASIS Issues Tracker <>
Date
2018-07-09T18:04:01+00:00
ID
Thread
[OASIS Issue Tracker] (OFFICE-3856) Missing zero population size error cases in some OpenFormula statistical function definitions
[ https://issues.oasis-open.org/browse/OFFICE-3856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=70445#comment-70445 ] 

Patrick Durusau commented on OFFICE-3856:
-----------------------------------------

Clone of https://issues.oasis-open.org/browse/OFFICE-3982 ODF 1.2 Errata 01

> Missing zero population size error cases in some OpenFormula statistical function definitions
> ---------------------------------------------------------------------------------------------
>
>                 Key: OFFICE-3856
>                 URL: https://issues.oasis-open.org/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.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
(v7.7.2#77003)