Calc/ODFF Implementation/Examine functions

From Apache OpenOffice Wiki
< Calc‎ | ODFF Implementation
Revision as of 01:06, 19 October 2008 by Regina (Talk | contribs)

Jump to: navigation, search

Examine Changes in Functions for ODFv1.2

This is a collection of the differences I found and what I know is already done or in progress. I also note, when I found problems in the draft spec itself. You are invited to add your observations. Regina 19:40, 10 October 2008 (CEST)

Statistical Functions

Function ODFv1.2 CALC Action Progress
BETADIST Draft Spec misses faktor 1/(b-a) in densitiy case not yet implemented Inform Eike Rathke
Has density case and optional parameter, to choose between density and cumulative not yet implemented expand function to density case and additional parameter tracked in Issue 91547 , function code is ready, finishing implementation depends on Issue 91602
BINOMDIST Parameter C is integer with constraint to 0 and 1. It should be Logical than in other distributions C=0 is density, all other values of C are treated as cumulative - -
LEGACY.CHIDIST Returns 1 for x <0 x < 0 returns Err:502 expand domain to x < 0 internal patch in Issue 94555
CHISQDIST density function and cumulative left tail of chi-square distribution not yet implemented prepare Implementation patch in Issue 94555
CHISQINV inverse of CHISQDIST(...TRUE()) not yet implemented prepare Implementation patch in Issue 94555
EXPONDIST Parameter Cumulative has type Logical and is optional. Last Parameter C has type Number and is not optional. C=0 returns denisity, other values for C return cumulative function. - -
FDIST density function and cumulative left tail of F-distribution not yet implemented prepare for implementation first draft, depends on BETADIST Issue 91547
Name conflicts with actual FDIST, which calculates right tail. get new UI-name have brought problem to dev@sc
FINV inverse of new FDIST not yet implemented - -
Name conflicts with actual FINV, which calculates inverse for right tail. get new UI-name -
GAMMA Parameter is constraint to >= 0 Gamma is definied for all real numbers, but non-positive integers Inform Eike Rathke -
not yet implemented prepare implementation using full domain. Add UI texts. path in Issue 94555
is in subgroup Mathematical functions will go to subgroup Statistical functions
GAMMALN is in subgroup Mathematical Functions is in subgroup Statistical Functions - -
GAMMADIST Last Parameter has type Logical Last Parameter has type Number Change type internal to bool. Change UI texts. patch in Issue 94555
Domain for Parameter x includes x < 0 x < 0 returns Err:502 in OOo2.* Change implementation integrated in OOo3.0
GROWTH Last parameter has type Logical (in Excel too) Last parameter has type Number - -
is in subgroup Statistical Functions (in Excel too) is in subgroup Array Functions - -
HYPGEOMDIST Optional, logical parameter to calculate "exact" or "at most" no parameter, calculates always "exact" - -
INTERCEPT Current, "Calculates the point at which a line will intersect the y-values by using known x-values and y-values." (BTW: That is literally from Excel help.) Problems:1. It calculates no point but a single value. 2. The line does not intersect the y-values but the y-axis. 3. It does not say, that the line is the linear regression of the known values. - - -
NORMDIST Last Parameter has type Logical and is optional Last Parameter has type Number and is required - -
LEGACY.NORMSDIST "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional. - -
PERCENTRANK It has an optional parameter Significance not yet implemented - -
PHI Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution - - -
POISSON Parameter Cumulative has type Logical and is optional. Parameter 'C' is required. 'C'=0 is density function, all others are cumulative - -
TDIST Draft spec shows the density function. Calc (and Excel) evaluates the cumulative function. Inform Eike Rathke
Functionname ODF Calc Action Progress

Other Functions

Function ODFv1.2 CALC Action Progress
GCD "Return the largest value that can be evenly divided (no remainder) into the given numbers." Should be "Return the largest value that can divide the given numbers evenly (no remainder)." - - -
Functionname ODF Calc Action Progress

Personal tools