Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2020

Multiple versions of the standard normal density function

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      I propose that we leave the draft as is. There is a large body of documents that use the Legacy.Normsdist syntax. On load of docments, processing function names that do not have a 1 to 1 mapping is something we should avoid.

      Show
      I propose that we leave the draft as is. There is a large body of documents that use the Legacy.Normsdist syntax. On load of docments, processing function names that do not have a 1 to 1 mapping is something we should avoid.

      Description

      In the current draft,

      LEGACY.NORMSDIST( x ) and NORMDIST(x,0,1) are supposed to be the same. Moreover GAUSS 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!

        Attachments

          Activity

            People

            • Assignee:
              ericpa Eric Patterson
              Reporter:
              aguelzow Andreas Guelzow
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: