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] Commented: (OFFICE-2020) Multiple versions ofthe standard normal density function

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16808#action_16808 ] 

Eike Rathke commented on OFFICE-2020:

Currently AFAIK no implementation has the NORMDIST parameters optional. Writing existing documents that use GAUSS in terms of NORMDIST would require a conversion from GAUSS(x) to (NORMDIST(x;0;1;1)-0.5)
I see GAUSS as a user convenience function and think we should drop it only if implementations have the NORMDIST parameters optional, otherwise the resulting expression is clumsy.
Regarding LEGACY.NORMSDIST I propose to postpone dropping it for ODF-Next.

> Multiple versions of the standard normal density function
> ---------------------------------------------------------
>                 Key: OFFICE-2020
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2020
>             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
> In the current draft,
> LEGACY.NORMSDIST( x ) and NORMDIST(x,0,1)  are supposed to be the same. Moreover GAUSS(x) is supposed to be the above minus 0.5.
> It would make much more sense to make the second and third argument of NORMDIST optional and drop LEGACY.NORMSDIST and GAUSS!

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]