Difference between revisions of "Calc/ODFF Implementation/Examine functions"
From Apache OpenOffice Wiki
< Calc | ODFF Implementation
(→Examine Changes in Functions for ODFv1.2) |
(→Examine Changes in Functions for ODFv1.2) |
||
Line 1: | Line 1: | ||
== Examine Changes in Functions for ODFv1.2 == | == 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. [[User:Regina|Regina]] 19:40, 10 October 2008 (CEST) | 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. [[User:Regina|Regina]] 19:40, 10 October 2008 (CEST) | ||
+ | |||
+ | === Statistical Functions === | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Function !! ODFv1.2 !! CALC !! Action !! Progress || | ! Function !! ODFv1.2 !! CALC !! Action !! Progress || | ||
+ | |||
|- | |- | ||
! BETADIST | ! BETADIST | ||
Line 44: | Line 47: | ||
|- | |- | ||
− | |||
! GAMMA | ! GAMMA | ||
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || - || | | Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || - || | ||
|- | |- | ||
− | | || ||not yet implemented || prepare implementation using full domain. Add UI texts. || path in {{Bug|94555}}|| | + | | || ||not yet implemented || prepare implementation using full domain. Add UI texts. || path in {{Bug|94555}}|| |
+ | |- | ||
+ | | ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || || || | ||
+ | |||
+ | |- | ||
+ | ! GAMMALN | ||
+ | | is in subgroup Mathematical functions || is in subgroup Statistical functions || - || - || | ||
|- | |- | ||
Line 59: | Line 67: | ||
! TDIST | ! TDIST | ||
| Draft spec shows the density function. || Calc (and Excel) evaluates the cumulative function. || Inform [[User:ErAck|Eike Rathke]] || Done 2008-10-09 || | | Draft spec shows the density function. || Calc (and Excel) evaluates the cumulative function. || Inform [[User:ErAck|Eike Rathke]] || Done 2008-10-09 || | ||
+ | |||
+ | |- | ||
+ | ! Functionname | ||
+ | | ODF || Calc || Action || Progress || | ||
+ | |} | ||
+ | |||
+ | === Other Functions === | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |||
+ | |- | ||
+ | ! 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)."|| - || - || - || | ||
|- | |- |
Revision as of 14:54, 14 October 2008
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 | Done 2008-06-07 | |
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 | ||
TDIST | Draft spec shows the density function. | Calc (and Excel) evaluates the cumulative function. | Inform Eike Rathke | Done 2008-10-09 | |
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 |