https://wiki.openoffice.org/w/api.php?action=feedcontributions&feedformat=atom&user=MakicaApache OpenOffice Wiki - User contributions [en]2026-08-27T20:55:32ZUser contributionsMediaWiki 1.35.14https://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=188050Calc/ODFF Implementation/Examine functions2010-11-12T15:05:04Z<p>Makica: /* Other Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || implemented || implementation by Marina (makkica) || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || implementation by Wolfgang (wope)||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || implementation by Wolfgang (wope)||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || implementation by Wolfgang (wope)||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || implementatin by Wolfgang (wope)||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || implementation by Wolfgang (wope)||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=OpenOffice.org_Internship/Projects/2010/Add_new_spreadsheet_functions_and_parameters_according_to_ODFF&diff=188048OpenOffice.org Internship/Projects/2010/Add new spreadsheet functions and parameters according to ODFF2010-11-12T15:02:30Z<p>Makica: /* Project status */</p>
<hr />
<div>{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}<br />
<br />
__TOC__<br />
<br />
== Overview ==<br />
The [[OpenDocument| OASIS OpenDocument Format (ODF)]] specification part 2, OpenFormula aka ODFF, standardizes on recalulcated formula expression as used by [[Calc]] and introduces new functions and parameters that need to be implemented.<br />
<br />
== Project plan ==<br />
* Align and enhance the already existing [[Calc/ODFF_Implementation/Examine_functions| overview and comparison]] of differences between implemented spreadsheet functions and the current ODFF draft.<br />
* Determine the most important functions to be implemented.<br />
* Implement functions in<br />
** compiler<br />
** interpreter<br />
** function wizard resources<br />
<br />
=== Documentation ===<br />
* Code documentation.<br />
* Function and parameter descriptions in the Formula Wizard.<br />
* Provide input for the online help / documentation team.<br />
<br />
== Project status ==<br />
* The project is accepted for the OpenOffice.org summer internship program 2010<br />
* Evaluation and comparison is done.<br />
* AVERAGEIF and XOR are done.<br />
* AVERAGEIFS, COUNTIFS and SUMIFS are implemented.<br />
* IFERROR and IFNA functions are ongoing.<br />
<br />
<br />
[[Category:Marketing]]<br />
[[Category:Development]]<br />
[[Category:Calc]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=OpenOffice.org_Internship/Projects/2010/Add_new_spreadsheet_functions_and_parameters_according_to_ODFF&diff=180743OpenOffice.org Internship/Projects/2010/Add new spreadsheet functions and parameters according to ODFF2010-08-30T16:47:08Z<p>Makica: /* Project status */</p>
<hr />
<div>{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}<br />
<br />
__TOC__<br />
<br />
== Overview ==<br />
The [[OpenDocument| OASIS OpenDocument Format (ODF)]] specification part 2, OpenFormula aka ODFF, standardizes on recalulcated formula expression as used by [[Calc]] and introduces new functions and parameters that need to be implemented.<br />
<br />
== Project plan ==<br />
* Align and enhance the already existing [[Calc/ODFF_Implementation/Examine_functions| overview and comparison]] of differences between implemented spreadsheet functions and the current ODFF draft.<br />
* Determine the most important functions to be implemented.<br />
* Implement functions in<br />
** compiler<br />
** interpreter<br />
** function wizard resources<br />
<br />
=== Documentation ===<br />
* Code documentation.<br />
* Function and parameter descriptions in the Formula Wizard.<br />
* Provide input for the online help / documentation team.<br />
<br />
== Project status ==<br />
* The project is accepted for the OpenOffice.org summer internship program 2010<br />
* Evaluation and comparison is done.<br />
* AVERAGEIF and XOR are done.<br />
* Implementing AVERAGEIFS, COUNTIFS and SUMIFS functions are ongoing.<br />
<br />
<br />
[[Category:Marketing]]<br />
[[Category:Development]]<br />
[[Category:Calc]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=OpenOffice.org_Internship/Projects/2010/Add_new_spreadsheet_functions_and_parameters_according_to_ODFF&diff=180742OpenOffice.org Internship/Projects/2010/Add new spreadsheet functions and parameters according to ODFF2010-08-30T16:46:50Z<p>Makica: /* Project status */</p>
<hr />
<div>{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}<br />
<br />
__TOC__<br />
<br />
== Overview ==<br />
The [[OpenDocument| OASIS OpenDocument Format (ODF)]] specification part 2, OpenFormula aka ODFF, standardizes on recalulcated formula expression as used by [[Calc]] and introduces new functions and parameters that need to be implemented.<br />
<br />
== Project plan ==<br />
* Align and enhance the already existing [[Calc/ODFF_Implementation/Examine_functions| overview and comparison]] of differences between implemented spreadsheet functions and the current ODFF draft.<br />
* Determine the most important functions to be implemented.<br />
* Implement functions in<br />
** compiler<br />
** interpreter<br />
** function wizard resources<br />
<br />
=== Documentation ===<br />
* Code documentation.<br />
* Function and parameter descriptions in the Formula Wizard.<br />
* Provide input for the online help / documentation team.<br />
<br />
== Project status ==<br />
* The project is accepted for the OpenOffice.org summer internship program 2010<br />
* Evaluation and comparison is done.<br />
* AVERAGEIF and XOR are done.<br />
* Implementing AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.<br />
<br />
<br />
[[Category:Marketing]]<br />
[[Category:Development]]<br />
[[Category:Calc]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=180741Calc/ODFF Implementation/Examine functions2010-08-30T16:45:41Z<p>Makica: /* Other Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || implemented || implementation by Marina (makkica) || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=180740Calc/ODFF Implementation/Examine functions2010-08-30T16:44:47Z<p>Makica: /* Other Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || implemented || implementation by Marina (makkica) || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=180739Calc/ODFF Implementation/Examine functions2010-08-30T16:44:11Z<p>Makica: /* Statistical Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || implemented || implementation by Marina (makkica) || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=180738Calc/ODFF Implementation/Examine functions2010-08-30T16:40:12Z<p>Makica: /* Other Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || implemented || implementation by Marina (makkica) || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=Calc/ODFF_Implementation/Examine_functions&diff=180737Calc/ODFF Implementation/Examine functions2010-08-30T16:38:59Z<p>Makica: /* Statistical Functions */</p>
<hr />
<div>== Examine Changes in Functions for ODFv1.2 ==<br />
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)<br />
<br />
=== Statistical Functions ===<br />
<br />
{| class="wikitable"<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! AVERAGEIF<br />
| || implemented || implementation by Marina (makkica) ||{{bug|101466}} ||<br />
<br />
|-<br />
! AVERAGEIFS<br />
| || not implemented yet || ||{{bug|101466}} ||<br />
<br />
|-<br />
! BETADIST<br />
| Draft Spec misses faktor 1/(b-a) in densitiy case || not yet implemented || Inform [[User:ErAck|Eike Rathke]] ||correct in draft 22a of ODFF ||<br />
|-<br />
| ||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 {{Bug|91547}} || integrated in OOo3.2||<br />
<br />
|-<br />
! BINOMDIST<br />
| Parameter C is integer with constraint to 0 and 1. It should be Logical as in other distributions || C=0 is density, all other values of C are treated as cumulative || || ||<br />
<br />
|-<br />
! LEGACY.CHIDIST<br />
| Returns 1 for x &lt;0 || x &lt; 0 returns Err:502 || expand domain to x &lt; 0 internal,patch in {{Bug|94555}} ||integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQDIST<br />
| density function and cumulative left tail of chi-square distribution || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! CHISQINV<br />
| inverse of CHISQDIST(...TRUE()) || not yet implemented || prepare Implementation, patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
<br />
|-<br />
! EXPONDIST<br />
| 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. || || ||<br />
<br />
|-<br />
! FDIST<br />
| density function and cumulative left tail of F-distribution || not yet implemented|| prepare for implementation || first draft, depends on BETADIST {{Bug|91547}} ||<br />
|-<br />
| || || Name conflicts with actual FDIST, which calculates right tail. OOo2.4 does not handle namespace correctly and takes new FDIST as old one || get new UI-name || have brought problem to dev@sc ||<br />
<br />
|-<br />
! FINV<br />
| inverse of new FDIST || not yet implemented || || ||<br />
|-<br />
| || || Name conflicts with actual FINV, which calculates inverse for right tail. || get new UI-name || ||<br />
<br />
|-<br />
! GAMMA<br />
| Parameter is constraint to >= 0 || Gamma is definied for all real numbers, but non-positive integers || Inform [[User:ErAck|Eike Rathke]] || ||<br />
|-<br />
| || ||not yet implemented || prepare implementation using full domain. Add UI texts. patch in {{Bug|94555}} || integrated in OOo3.2||<br />
|-<br />
| ||is in subgroup Mathematical functions || will go to subgroup Statistical functions || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! GAMMALN<br />
| is in subgroup Mathematical Functions || is in subgroup Statistical Functions || || ||<br />
<br />
|-<br />
! GAMMADIST<br />
| Last Parameter has type Logical || Last Parameter has type Number || Change type internal to bool. Change UI texts. patch in {{Bug|94555}} || integrated in OOo3.2 ||<br />
|-<br />
| ||Domain for Parameter x includes x &lt; 0 || x &lt; 0 returns Err:502 in OOo2.* || Change implementation || integrated in OOo3.0 ||<br />
<br />
|-<br />
! GROWTH<br />
| Last parameter has type Logical (in Excel too) || Last parameter has type Number || || ||<br />
|-<br />
| ||is in subgroup Statistical Functions (in Excel too) || is in subgroup Array Functions || || ||<br />
<br />
|-<br />
! HYPGEOMDIST<br />
| Optional, logical parameter to calculate "exact" or "at most" || no parameter, calculates always "exact" || || ||<br />
<br />
|-<br />
! INTERCEPT<br />
| 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.|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! NORMDIST<br />
| Last Parameter has type Logical and is optional || Last Parameter has type Number and is required ||Change implementation, {{Bug|100119}}|| integrated in OOo3.2||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC.{{Bug|69069}}, {{Bug|97091}} ||integrated in OOo3.2||<br />
<br />
|-<br />
! LEGACY.NORMSDIST<br />
| "This is exactly NORMDIST(x)." Should be "This is exactly NORMDIST(x;0;1)." because mean parameter and standard deviation parameter are not optional.|| || ||correct in draft 22a of ODFF ||<br />
|-<br />
| || ||Accuracy is insufficient for x&lt;&minus;2 because cancellation.||New implementation with ERFC. {{Bug|69069}}, {{Bug|97091}}|| integrated in OOo3.2||<br />
<br />
|-<br />
! LOGNORMDIST<br />
| Four parameters, all but first parameter are optional ||Three parameters, all required||Change implementation {{Bug|100119}}|| integrated in OOo3.2 ||<br />
<br />
|-<br />
! PERCENTRANK<br />
| It has an optional parameter ''Significance''||not yet implemented|| || ||<br />
<br />
|-<br />
! PHI<br />
| Description is unclear. PHI(x)=NORMDIST(x;0;1;FALSE()). It is the density function of the standard normal distribution || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! POISSON<br />
| Parameter ''Cumulative'' has type Logical and is optional.|| Parameter 'C' is required. 'C'=0 is density function, all others are cumulative||change in calc {{Bug|96837}}|| integrated in OOo3.1||<br />
<br />
|-<br />
! QUARTILE<br />
| Example calculates with ''Quart=1.5'' although there is a constraint INT(Quart)=Quart|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/]||<br />
<br />
|-<br />
! RANK<br />
| Description "If not 0, Data is ranked in descending order." has to be "If not 0, Data is ranked in ascending order."|| || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! SKEWP<br />
| || not yet implemented|| || ||<br />
<br />
|-<br />
! STDEVA<br />
| The text "cells with text are converted to 0;" conflicts with "The handling of strings is implementation defined."|| || ||Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! TDIST<br />
| In Draft 26 it was corrected to show the cumulative function. In addition it was renamed to LEGACY.TDIST to be consistent with other right tailed distributions. || Calc (and Excel) evaluates the cumulative function. ||Implementation has to be adapted.|| not started ||<br />
<br />
|-<br />
! TREND<br />
| The optional parameters ''knownX'' and ''newX'' may be empty, denoted as ;;|| ''knownX'' and ''knownY'' cannot be empty|| || ||<br />
|-<br />
| ||Parameter ''AllowOffset'' is Logical|| Parameter is 0 or ''not 0''|| || ||<br />
<br />
|-<br />
! TRIMMEAN<br />
| The limits in the definition formula are wrong. Either count i from 0, then sum from i=cutOff to n&minus;1&minus;cutOff, or count i from 1, then sum from i=cutOff+1 to n&minus;cutOff || || ||correct in draft 22a of ODFF ||<br />
<br />
|-<br />
! TTEST<br />
| (1) All formulas miss the degrees of freedom. It is necessary for TDIST. In case unequal variance there must be defined, whether the degrees of freedom are made integer by FLOOR or whether they remain real. (2) case paired: <math>\scriptstyle \sqrt {n-1}</math> is wrong because it is already contained in <math> s_{X_1 - X_2}</math>. (3) case equal variance: definition of s² is missing. (4) case unequal variance: definition does not meet usual definitions. In fact it is the definition for the equal variance case, with pooled variance.(5) As TDIST actually returns the values of the CDF, this formulas has to be revised together with TDIST.|| ||Corrent implementation fits to draft, no action needed. ||draft 22a of ODFF has got correct definition for type 2 and 3, type 1 has got an error, which will be corrected soon. || <br />
<br />
|-<br />
! WEIBULL<br />
| Parameter ''Cumulative'' is logical.||Parameter is 0 or ''not 0''|| || ||<br />
|-<br />
| ||Alpha and Beta are exchanged in the formula, compared with the current implementation in OOo, Excel and Gnumeric.|| || ||Draft 22a of ODFF has got a better description. ||<br />
<br />
|-<br />
! ZTEST<br />
| || Calc calculates z-value wrong. Read discussion in {{Bug|90759}} || Correct sigma-bug|| integrated in OOo3.2||<br />
|-<br />
| || || Uses instable algorithm for standard deviation.||Change to stable version or use STDEV directly.|| ||<br />
|-<br />
| || Calculates <math>\scriptstyle 1-P( -|z| \le Z \le |z|)</math>|| Beside the sigma-bug OOo calculates <math>\scriptstyle 1-P( Z \le z)</math> for z&gt;0 and <math>\scriptstyle P( Z \le |z|)</math> for z&lt;0|| || Mail to OASIS [http://lists.oasis-open.org/archives/office-comment/] ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
=== Other Functions ===<br />
<br />
{| class="wikitable"<br />
<br />
|-<br />
! Function !! ODFv1.2 !! CALC !! Action !! Progress ||<br />
<br />
|-<br />
! CEILING<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! FLOOR<br />
| Already second parameter (significance) is optional. || Only third parameter (mode) is optional. || Change in Calc and write additional parameter to file for backwards compatibility (not that easy because the actual value depends on the first parameter). <br> Until then let at least the interpreter handle it as optional. || - ||<br />
<br />
|-<br />
! GCD<br />
| "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)."|| - || - || Text is correct since OpenFormula draft 22.||<br />
<br />
|-<br />
! LOG<br />
| Base (third parameter) is optional with default 10.||All parameters are required.||Change in Calc||Done (Lvyue) {{Bug|96835}}, integrated to OOo3.1||<br />
<br />
|-<br />
! ISOWEEKNUM<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! DATEDIF<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! PDURATION<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! COUNTIFS<br />
| || not implemented yet || ||{{bug|90269}}||<br />
<br />
|-<br />
! NUMBERVALUE<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! XOR<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IFERROR<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! IFNA<br />
| || not implemented yet || ||{{bug|92677}} ||<br />
<br />
|-<br />
! CSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! CSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111413}} ||<br />
<br />
|-<br />
! SUMIFS<br />
| || not implemented yet || ||{{bug|95144}} ||<br />
<br />
|-<br />
! BITAND<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITLSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITRSHIFT<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! BITXOR<br />
| || not implemented yet || ||{{bug|111519}} ||<br />
<br />
|-<br />
! FINDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LEFTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! LENB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! MIDB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! REPLACEB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! RIGHTB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! SEARCHB<br />
| || not implemented yet || || ||<br />
<br />
|-<br />
! IMCSCH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSEC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMSECH<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMTAN<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]]||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCOT<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! IMCSC<br />
| || not implemented yet ||Implementation by [[User:Regina|Regina]] ||Patch in {{bug|111609}} ||<br />
<br />
|-<br />
! Functionname<br />
| ODF || Calc || Action || Progress ||<br />
|}<br />
<br />
----<br />
[[Category:Calc]]<br />
[[Category:To-Do]]</div>Makicahttps://wiki.openoffice.org/w/index.php?title=OpenOffice.org_Internship/Projects/2010/Add_new_spreadsheet_functions_and_parameters_according_to_ODFF&diff=177554OpenOffice.org Internship/Projects/2010/Add new spreadsheet functions and parameters according to ODFF2010-08-09T15:19:42Z<p>Makica: /* Project status */</p>
<hr />
<div>{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}<br />
<br />
__TOC__<br />
<br />
== Overview ==<br />
The [[OpenDocument| OASIS OpenDocument Format (ODF)]] specification part 2, OpenFormula aka ODFF, standardizes on recalulcated formula expression as used by [[Calc]] and introduces new functions and parameters that need to be implemented.<br />
<br />
== Project plan ==<br />
* Align and enhance the already existing [[Calc/ODFF_Implementation/Examine_functions| overview and comparison]] of differences between implemented spreadsheet functions and the current ODFF draft.<br />
* Determine the most important functions to be implemented.<br />
* Implement functions in<br />
** compiler<br />
** interpreter<br />
** function wizard resources<br />
<br />
=== Documentation ===<br />
* Code documentation.<br />
* Function and parameter descriptions in the Formula Wizard.<br />
* Provide input for the online help / documentation team.<br />
<br />
== Project status ==<br />
* The project is accepted for the OpenOffice.org summer internship program 2010<br />
* Evaluation and comparison is done.<br />
* Implementing AVERAGEIF, AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.<br />
<br />
<br />
[[Category:Marketing]]<br />
[[Category:Development]]<br />
[[Category:Calc]]</div>Makica