Difference between revisions of "Calc/Drafts/Treatment of new Excel 2010 functions"

< Calc‎ | Drafts
Jump to: navigation, search

This article is a workspace for discussing the treatment of new functions of Excel 2010 in OpenOffice.org code. For using functions in spreadsheets look at Documentation/How_Tos/Calc:_Functions_listed_alphabetically

Please do not chance the layout to a table. Such table makes it hard to edit a single section.

You want to help collecting the information? Try to add: Which parameters has the function? Does a corresponding OOo function exists already? Does a corresponding function exists in ODF 1.2? How difficult is it to implement a new function if necessary? Do you see any problems or obstacles?

Reference Documents

The discussion uses the description of the new functions in Function Improvements in Microsoft Office Excel 2010 and in What's New: Changes made to Excel functions and the connected descriptions of the functions.

For ODF 1.2 the actual document from OpenDocument - Formula SC Public Documents is used.

new

renamed BETADIST

renamed BETAINV

BINOM.DIST

renamed BINOMDIST

BINOM.INV

renamed CRITBINOM

CHISQ.DIST

new

Excel
CHISQ.DIST(x,deg_freedom,cumulative), all parameters required
x >= 0
deg_freedom is truncated to integer, 0<deg_freedom<=10^10
cumulative is logical, but numbers are accepted too
ODF1.2
CHISQDIST( Number x ; Number DegreesOfFreedom [ ; Logical Cumulative = TRUE() ] )
OOo3.2
is already implemented as ODF1.2 definies
no constraints for x
DegreesOfFreedom are truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom

Comment

Directly mapping is possible in import.

renamed CHIDIST

CHISQ.INV

new

Excel
CHISQ.INV(probability,deg_freedom), both arguments required
0<=probability<1,
1<=deg_freedom<=10^10, deg_freedom is truncated to integer
ODF1.2
CHISQINV( Number p ; Number DegreesOfFreedom )
0<=p<1
DegreesOfFreedom is a positive integer
OOo3.2
is already implemented as CHISQINV as ODF1.2 defines
0<=p<1
DegreesOfFreedom is truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom, but calculation might not converge

Comment

Directly mapping is possible in import.

renamed CHIINV

renamed CHITEST

CONFIDENCE.NORM

renamed CONFIDENCE

new

renamed COVAR

new

EXPON.DIST

renamed EXPONDIST

new

renamed FDIST

new

renamed FINV

renamed FTEST

GAMMA.DIST

renamed GAMMADIST

renamed GAMMAINV

HYPGEOM.DIST

renamed HYPGEOMDIST

new

LOGNORM.DIST

renamed LOGNORMDIST

renamed LOGINV

new

renamed MODE

NEGBINOM.DIST

renamed NEGBINOMDIST

new

renamed NORMDIST

renamed NORMINV

NORM.S.DIST

renamed NORMSDIST

renamed NORMSINV

new

PERCENTILE.INC

renamed PERCENTILE

new

PERCENTRANK.INC

renamed PERCENTRANK

renamed POISSON

new

renamed QUARTILE

new

renamed RANK

renamed STDEVP

renamed STDEV

new

renamed TDIST

renamed TDIST

new

renamed TINV

renamed TTEST

renamed VARP

renamed VAR

renamed WEIBULL

new

renamed ZTEST