Calc/ODFF Implementation/Examine functions
From Apache OpenOffice Wiki
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 | - | - | |
QUARTILE | Example calculates with Quart=1.5 although there is a constraint INT(Quart)=Quart | - | - | - | |
RANK | Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order." | - | - | - | |
SKEWP | - | not yet implemented | - | - | |
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 |