[sc-features] changed/CWS odff06 : NORMDIST, LOGNORMDIST parameters

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[sc-features] changed/CWS odff06 : NORMDIST, LOGNORMDIST parameters

eike.rathke


       Product: Spreadsheet
          Type: changed
         Title: NORMDIST, LOGNORMDIST parameters
     Posted by: [hidden email]
      Affected: sc
         TaskId: i100119
<http://www.openoffice.org/issues/show_bug.cgi?id=100119>
Effective from: CWS odff06
           CWS:
<http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/odff06>
    CWS status: new


*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [x]
UI relevant [x]


*Description*
-------------
- NORMDIST's 4th parameter is now optional.
  - 0 or FALSE calculates the probability density function. Any other
    value or TRUE or omitted calculates the cumulative distribution
    function.
    - If omitted, 1 is written to files for backwards compatibility.

- LOGNORMDIST's 2nd and 3rd parameters are now optional, an optional 4th
  parameter has been added.
  - The 2nd, mean, parameter has the default value 0 if omitted.
    - If omitted, 0 is written to files for backwards compatibility.
  - The 3rd, standard deviation, parameter has the default value 1 if
    omitted.
    - If omitted, 1 is written to files for backwards compatibility.
  - The 4th, cumulative, parameter is defined as
    - 0 or FALSE calculates the probability density function. Any other
      value or TRUE or omitted calculates the cumulative distribution
      function.
    - If a value was given, earlier releases reading the file cannot
      interpret the function and return an error.

These changes align with the definitions given in the OASIS
ODFF/OpenFormula specification available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula



Send feedback to [hidden email]



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]