Jump to content

Development/ODF Implementer Notes/List of LibreOffice OpenFormula Extensions

From The Document Foundation Wiki

This page contains a list of all LibreOffice OpenFormula Extensions -- functions that we've added to LibreOffice to extend what's available in the OpenFormula specification. A list of known functions which are not implemented in LibreOffice can be access at Development/Calc/Spreadsheet Functions/not yet implemented.

LibreOffice OpenFormula extensions

The OpenFormula specification permits implementations to use namespaces in function names similar to how they're used in xml proper. This page lists the non-default extensions contained in LibreOffice.

Namespace: ORG.LIBREOFFICE

Commit Added to master Affects LO Versions Full Name

(with Namespace)

Function name in UI Code pointer Description Notes OASIS cross-reference Standardized in ODFF Standardized as...
OPCODE appears in dd0f84 2014-05-19 4.4 ORG.LIBREOFFICE.COLOR COLOR sc/source/core/tool/interpr7.cxx ScInterpreter::ScColor() Returns an ARGB value.
OPCODE appears in db1e34 2015-12-16 5.2 ORG.LIBREOFFICE.RAWSUBTRACT RAWSUBTRACT sc/source/core/tool/interpr6.cxx ScInterpreter::ScRawSubtract() Returns subtrahend(s) subtracted from minuend without cancelling roundoff errors.
OPCODE appears in f336f6 2016-03-03 5.2 ORG.LIBREOFFICE.FORECAST.ETS.MULT FORECAST.ETS.MULT sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() Returns forecasted value(s) calculated with triple/double exponential smoothing algorithms, using the multiplicative method.
OPCODE appears in f336f6 2016-03-03 5.2 ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT FORECAST.ETS.PI.MULT sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() Returns prediction interval(s) for forecasted value(s) calculated with triple/double exponential smoothing algorithms, using the multiplicative method, with the appropiate confidence levels passed as argument.
OPCODE appears in f336f6 2016-03-03 5.2 ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT FORECAST.ETS.STAT.MULT sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() Returns statistical value(s) for forecast calculations with triple/double exponential smoothing algorithms, using the multiplicative method.
OPCODE appears in 902c59 2016-01-05 5.1 ORG.LIBREOFFICE.WEEKNUM_OOO WEEKNUM_OOO sc/source/core/tool/interpr2.cxx ScInterpreter::ScWeeknumOOo() compatibility function for old behaviour of WEEKNUM, which was not ODFF compliant, see tdf#50950
OPCODE appears in 3ee1c4 2017-02-20 5.4 ORG.LIBREOFFICE.ROUNDSIG ROUNDSIG sc/source/core/tool/interpr2.cxx ScInterpreter::ScRoundSignificant() Return value in specified number of significant digits, see tdf#105931
OPCODE appears in 8dec85 2018-10-25 6.2 ORG.LIBREOFFICE.REGEX REGEX sc/source/core/tool/interpr1.cxx ScInterpreter::ScRegex() Matches and extracts or optionally replaces text using regular expressions, see tdf#113977
OPCODE appears in 32d9f7 2019-02-16 6.3 ORG.LIBREOFFICE.FOURIER FOURIER sc/source/core/tool/interpr3.cxx ScInterpreter::ScFourier() Calculates Fourier analysis, see tdf#74664
OPCODE appears in 716655 2020-04-28 7.0 ORG.LIBREOFFICE.RAND.NV RAND.NV sc/source/core/tool/interpr1.cxx ScInterpreter::ScRandom() Non-volatile random number generating function that is not recalculated on every input, see tdf#127831
OPCODE appears in 716655 2020-04-28 7.0 ORG.LIBREOFFICE.RANDBETWEEN.NV RANDBETWEEN.NV sc/source/core/tool/interpr1.cxx ScInterpreter::ScRandbetween() Non-volatile random integer generating function that is not recalculated on every input, see tdf#127831

Namespace: ORG.OPENOFFICE

Commit Added to master Affects LO Versions Full Name

(with Namespace)

Function name in UI Code pointer Description Notes OASIS cross-reference Standardized in ODFF Standardized as...
OPCODE appears in 2cb4c6 2009-01-08 All ORG.OPENOFFICE.CURRENT CURRENT sc/source/core/tool/interpr2.cxx ScInterpreter::ScCurrent() Returns the expression's value at the current position.
Name fixed in 18e758 2008-07-22 All ORG.OPENOFFICE.ERRORTYPE ERRORTYPE sc/source/core/tool/interpr1.cxx ScInterpreter::ScErrorType() Returns the internal error number. This is not the ERROR.TYPE function as defined by ODFF.
OPCODE appears in 2cb4c6 2009-01-08 All ORG.OPENOFFICE.MULTIRANGE MULTIRANGE sc/source/core/tool/interpr1.cxx ScInterpreter::ScMultiArea() Legacy form of range list Deprecated legacy form of range list.
Not available in Function Wizard.
1.2 Replaced by ODFF Infix Operator Reference Concatenation ("~") (aka Union)
OPCODE appears in 2cb4c6 2009-01-08 All ORG.OPENOFFICE.STYLE STYLE sc/source/core/tool/interpr2.cxx ScInterpreter::ScStyle() Applies a style to the cell containing the formula expression.
OPCODE appears in 2cb4c6

Clarified vs CONVERT_ADD in 830249

2009-01-08

2013-12-02

All ORG.OPENOFFICE.CONVERT CONVERT sc/source/core/tool/interpr2.cxx ScInterpreter::ScConvert() Returns the conversion of a value with a factor that is defined in the configuration This is not the CONVERT function as defined by ODFF (which in the UI is CONVERT_ADD for historical reasons).
OPCODE appears in 2cb4c6

Write correct name 3deb83

2009-01-08

2011-12-07

All ORG.OPENOFFICE.EASTERSUNDAY EASTERSUNDAY sc/source/core/tool/interpr2.cxx ScInterpreter::ScEasterSunday() Calculates the date of Easter Sunday in a given year.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.WEEKS WEEKS scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffWeeks() Calculates the number of weeks in a specific period.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.MONTHS MONTHS scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffMonths() Calculates the number of months in a specific period.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.YEARS YEARS scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffYears() Calculates the number of years in a specific period.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.ISLEAPYEAR ISLEAPYEAR scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getIsLeapYear() Returns 1 (TRUE) if the date is a day of a leap year, otherwise 0 (FALSE).
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.DAYSINMONTH DAYSINMONTH scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDaysInMonth() Returns the number of days of the month in which the date entered occurs.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.DAYSINYEAR DAYSINYEAR scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDaysInYear() Returns the number of days of the year in which the date entered occurs.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.WEEKSINYEAR WEEKSINYEAR scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getWeeksInYear() Returns the number of weeks of the year in which the date entered occurs.
Name appears b785f9

Func not in ODF or Excel 27aeea

2008-01-10

2013-08-14

All ORG.OPENOFFICE.ROT13 ROT13 scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getRot13() "Encrypts" or decrypts a text using the ROT13 algorithm.

Namespace: COM.MICROSOFT

Commit Added to master Affects LO Versions Full Name

(with Namespace)

Function name in UI Code pointer Description Notes OASIS cross-reference Standardized in ODFF Standardized as...
OPCODE appears in 3edfc3 2008-01-10 All COM.MICROSOFT.BAHTTEXT BAHTTEXT sc/source/core/tool/interpr2.cxx ScInterpreter::ScBahtText() Returns the string representing a value in Thai Baht.
New Excel 2013 functions 24bce4

Full name used a21b79

2013-01-31

2013-08-14

4.1

4.2

COM.MICROSOFT.WEBSERVICE WEBSERVICE
New Excel 2013 functions 24bce4

Full name used a21b79

2013-01-31

2013-08-14

4.1

4.2

COM.MICROSOFT.FILTERXML FILTERXML
Add Excel 2010 Functions 6d2f42 2013-10-31 4.2 COM.MICROSOFT.BETA.DIST BETA.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScBetaDist_MS() Differs from BETADIST by different order of arguments and no default for cumulative
Add Excel 2010 Functions 6d2f42 2013-10-31 4.2 COM.MICROSOFT.BETA.INV BETA.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScBetaInv() Same as BETAINV
Add Excel 2010 Functions e362bc 2013-11-04 4.2 COM.MICROSOFT.BINOM.DIST BINOM.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScBinomDist() Same as BINOMDIST
Add Excel 2010 Functions e362bc 2013-11-04 4.2 COM.MICROSOFT.BINOM.INV BINOM.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScCritBinom() Same as BINOMINV and CRITBINOM
Add support for function ccbebd 2013-10-18 4.2 COM.MICROSOFT.COVARIANCE.P COVARIANCE.P sc/source/core/tool/interpr3.cxx ScInterpreter::ScCovarianceP() Same as COVAR
Add support for function ccbebd 2013-10-18 4.2 COM.MICROSOFT.COVARIANCE.S COVARIANCE.S sc/source/core/tool/interpr3.cxx ScInterpreter::ScCovarianceS() Returns the sample covariance
Add support for function 4a122d 2013-10-25 4.2 COM.MICROSOFT.STDEV.P STDEV.P sc/source/core/tool/interpr3.cxx ScInterpreter::ScStDevP() Same as STDEVP
Add support for function 4a122d 2013-10-25 4.2 COM.MICROSOFT.STDEV.S STDEV.S sc/source/core/tool/interpr3.cxx ScInterpreter::ScStDev() Same as STDEV
781363 2013-10-30 4.2 COM.MICROSOFT.VAR.P VAR.P sc/source/core/tool/interpr3.cxx ScInterpreter::ScVarP() Same as VARP
781363 2013-10-30 4.2 COM.MICROSOFT.VAR.S VAR.S sc/source/core/tool/interpr3.cxx ScInterpreter::ScVar() Same as VAR
756015 2013-11-08 4.2 COM.MICROSOFT.CHISQ.DIST CHISQ.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiSqDist_MS() Differs from CHISQDIST: X must be positive or 0, deg_of_freedom must be less than 10E10, cumulative is required
756015 2013-11-08 4.2 COM.MICROSOFT.CHISQ.INV CHISQ.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiSqInv() Same as CHISQINV
756015 2013-11-08 4.2 COM.MICROSOFT.CHISQ.TEST CHISQ.TEST sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiSqTest() Same as CHISQTEST
756015 2013-11-08 4.2 COM.MICROSOFT.CHISQ.DIST.RT CHISQ.DIST.RT sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiDist() Same as LEGACY.CHIDIST
756015 2013-11-08 4.2 COM.MICROSOFT.CHISQ.INV.RT CHISQ.INV.RT sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiInv() Same as LEGACY.CHIINV
53b2d2 2013-11-14 4.2 COM.MICROSOFT.CONFIDENCE.NORM CONFIDENCE.NORM sc/source/core/tool/interpr3.cxx ScInterpreter::ScConfidence() Same as CONFIDENCE
53b2d2 2013-11-14 4.2 COM.MICROSOFT.CONFIDENCE.T CONFIDENCE.T sc/source/core/tool/interpr3.cxx ScInterpreter::ScConfidenceT() Returns the confidence interval for a population mean, using a Student's t distribution.
e434c1 2013-11-22 4.2 COM.MICROSOFT.EXPON.DIST EXPON.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScExpDist() Same as EXPONDIST
5a1fa5 2013-11-20 4.2 COM.MICROSOFT.F.DIST F.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScFDist_LT() Returns the (left-tail) F probability distribution. Same as FDIST as defined by ODFF
5a1fa5 2013-11-20 4.2 COM.MICROSOFT.F.DIST.RT F.DIST.RT sc/source/core/tool/interpr3.cxx ScInterpreter::ScFDist() Same as FDIST
5a1fa5 2013-11-20 4.2 COM.MICROSOFT.F.INV F.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScFInv_LT() Returns the inverse of the (let-tailed) F probability distribution.
5a1fa5 2013-11-20 4.2 COM.MICROSOFT.F.INV.RT F.INV.RT sc/source/core/tool/interpr3.cxx ScInterpreter::ScFInv() Same as FINV
5a1fa5 2013-11-20 4.2 COM.MICROSOFT.F.TEST F.TEST sc/source/core/tool/interpr3.cxx ScInterpreter::ScFTest() Same as FTEST
853903 2013-11-29 4.2 COM.MICROSOFT.GAMMA.DIST GAMMA.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScGammaDist() Differs from GAMMADIST: cumulative is required
853903 2013-11-29 4.2 COM.MICROSOFT.GAMMA.INV GAMMA.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScGammaInv() Same as GAMMAINV
853903 2013-11-29 4.2 COM.MICROSOFT.GAMMALN.PRECISE GAMMALN.PRECISE sc/source/core/tool/interpr3.cxx ScInterpreter::ScLogGamma() Same as GAMMALN
e434c1 2013-11-22 4.2 COM.MICROSOFT.HYPGEOM.DIST HYPGEOM.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScHypGeomDist_MS() Differs from HYPGEOMDIST: extra argument cumulative (required)
e434c1 2013-11-22 4.2 COM.MICROSOFT.POISSON.DIST POISSON.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScPoissonDist() Same as POISSONDIST
e434c1 2013-11-22 4.2 COM.MICROSOFT.WEIBULL.DIST WEIBULL.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScWeibull() Same as WEIBULL
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.LOGNORM.DIST LOGNORM.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScLogNormDist() Differs from LOGNORMDIST: all 4 arguments are required
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.LOGNORM.INV LOGNORM.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScLogNormInv() Same as LOGNORMINV
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.NORM.DIST NORM.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScNormDist() Differs from NORMDIST: all 4 arguments are required
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.NORM.INV NORM.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScNormInv() Same as NORMINV
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.NORM.S.DIST NORM.S.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScStdNormDist_MS() Differs from NORMSDIST: extra argument, cumulative
Add Excel 2010 function 924f9d 2013-12-16 4.2 COM.MICROSOFT.NORM.S.INV NORM.S.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScSNormInv() Same as NORMSINV
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.DIST T.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScTDist_MS() Left-tailed Student's T-distribution (probability density or cumulative distribution function)
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.DIST.2T T.DIST.2T sc/source/core/tool/interpr3.cxx ScInterpreter::ScTDist_T() Same as TDIST(number, deg_of_freedom, 2)
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.DIST.RT T.DIST.RT sc/source/core/tool/interpr3.cxx ScInterpreter::ScTDist_T() Same as TDIST(number, deg_of_freedom, 1)
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.INV T.INV sc/source/core/tool/interpr3.cxx ScInterpreter::ScTInv() Left-tailed inverse of Student's T-distribution
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.INV.2T T.INV.2T sc/source/core/tool/interpr3.cxx ScInterpreter::ScTInv() Same as TINV
Add Excel 2010 function 5b1e44 2014-01-27 4.3 COM.MICROSOFT.T.TEST T.TEST sc/source/core/tool/interpr3.cxx ScInterpreter::ScTTest() Same as TTEST
8185ec 2014-01-30 4.3 COM.MICROSOFT.PERCENTILE.INC PERCENTILE.INC sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentile() Same as PERCENTILE
8185ec 2014-01-30 4.3 COM.MICROSOFT.PERCENTRANK.INC PERCENTRANK.INC sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentrank() Same as PERCENTRANK
8185ec 2014-01-30 4.3 COM.MICROSOFT.QUARTILE.INC QUARTILE.INC sc/source/core/tool/interpr3.cxx ScInterpreter::ScQuartile() Same as QUARTILE
8185ec 2014-01-30 4.3 COM.MICROSOFT.RANK.EQ RANK.EQ sc/source/core/tool/interpr3.cxx ScInterpreter::ScRank() Same as RANK
8185ec 2014-01-30 4.3 COM.MICROSOFT.PERCENTILE.EXC PERCENTILE.EXC sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentile() Differs from PERCENTILE: percentile value is exclusive boundaries (0, 1)
8185ec 2014-01-30 4.3 COM.MICROSOFT.PERCENTRANK.EXC PERCENTRANK.EXC sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentrank_MS() differs from PERCENTRANK: percentile value is exclusive boundaries (0, 1)
8185ec 2014-01-30 4.3 COM.MICROSOFT.QUARTILE.EXC QUARTILE.EXC sc/source/core/tool/interpr3.cxx ScInterpreter::ScQuartile() Differs from QUARTILE: percentile value is exclusive boundaries (0, 1)
8185ec 2014-01-30 4.3 COM.MICROSOFT.RANK.AVG RANK.AVG sc/source/core/tool/interpr3.cxx ScInterpreter::ScRank() Differs from RANK: if more than one value has the same rank, the average rank is returned.
e4def6 2014-03-05 4.3 COM.MICROSOFT.MODE.SNGL MODE.SNGL sc/source/core/tool/interpr3.cxx ScInterpreter::ScModalValue() Same as MODE
e4def6 2014-03-05 4.3 COM.MICROSOFT.MODE.MULT MODE.MULT sc/source/core/tool/interpr3.cxx ScInterpreter::ScModalValue_Multi() Differs from MODE, returns array of most frequently occurring values
e4def6 2014-03-05 4.3 COM.MICROSOFT.NEGBINOM.DIST NEGBINOM.DIST sc/source/core/tool/interpr3.cxx ScInterpreter::ScNegBinomDist_MS() Differs from NEGBINOMDIST: 4th argument (probability density or cumulative distribution)
e4def6 2014-03-05 4.3 COM.MICROSOFT.Z.TEST Z.TEST sc/source/core/tool/interpr3.cxx ScInterpreter::ScZTest() Same as ZTEST
ed7782 2014-03-10 4.3 COM.MICROSOFT.ISO.CEILING ISO.CEILING sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeiling_MS() Same as CEILING.PRECISE
ed7782 2014-03-10 4.3 COM.MICROSOFT.CEILING.PRECISE CEILING.PRECISE sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeiling_MS() Differs from CEILING: sign of 2nd argument (significance) does not matter, no 3rd argument (mode)
ed7782 2014-03-10 4.3 COM.MICROSOFT.FLOOR.PRECISE FLOOR.PRECISE sc/source/core/tool/interpr2.cxx ScInterpreter::ScFloor_Precise() Differs from FLOOR: sign of 2nd argument (significance) does not matter, no 3rd argument (mode)
010b2d 2015-04-29 5.0 COM.MICROSOFT.CEILING.MATH CEILING.MATH sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeil()
010b2d 2015-04-29 5.0 COM.MICROSOFT.CEILING CEILING.XCL sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeil_MS() Differs from CEILING: sign of 2nd argument (significance) does matter, no 3rd argument (mode)
cb13c4 2015-06-11 5.0 COM.MICROSOFT.FLOOR FLOOR.XCL sc/source/core/tool/interpr2.cxx ScInterpreter::ScFloor() Differs from FLOOR: sign of 2nd argument (significance) does matter, no 3rd argument (mode)
cb13c4 2015-06-11 5.0 COM.MICROSOFT.FLOOR.MATH FLOOR.MATH sc/source/core/tool/interpr2.cxx ScInterpreter::ScFloor_Math()
cb13c4 2015-06-11 5.0 COM.MICROSOFT.FLOOR.PRECISE FLOOR.PRECISE sc/source/core/tool/interpr2.cxx ScInterpreter::ScFloor_Precise() Differs from FLOOR: sign of 2nd argument (significance) does not matter, no 3rd argument (mode)
Add support for function 22dac2 2014-04-02 4.3 COM.MICROSOFT.NETWORKDAYS.INTL NETWORKDAYS.INTL sc/source/core/tool/interpr2.cxx ScInterpreter::ScNetWorkdays_MS() Differs from NETWORKDAYS: 3rd and 4th argument are other way round and workdays are defined differently
Add support for function 22dac2 2014-04-02 4.3 COM.MICROSOFT.WORKDAY.INTL WORKDAY.INTL sc/source/core/tool/interpr2.cxx ScInterpreter::ScWorkday_MS() Differs from WORKDAY: 3rd and 4th argument are other way round and workdays are defined differently
Add Excel 2010 function 56deaa 2014-04-11 4.3 COM.MICROSOFT.ERF.PRECISE ERF.PRECISE sc/source/core/tool/interpr7.cxx ScInterpreter::ScErf_MS() Differs from ERF: only one argument (lower boundary)
Add Excel 2010 function 56deaa 2014-04-11 4.3 COM.MICROSOFT.ERFC.PRECISE ERFC.PRECISE sc/source/core/tool/interpr7.cxx ScInterpreter::ScErfc_MS() Same as ERFC
Add Excel 2010 function 29c971 2014-04-25 4.3 COM.MICROSOFT.AGGREGATE AGGREGATE sc/source/core/tool/interpr1.cxx ScInterpreter::ScAggregate() Extension of SUBTOTAL: more functions, more filter options
Add Excel 2010 function 56deaa 9266ab 2015-01-26 5.0 COM.MICROSOFT.ENCODEURL ENCODEURL sc/source/core/tool/interpr7.cxx ScInterpreter::ScEncodeURL()
Add Excel 2016 function f336f6 2016-03-03 5.2 COM.MICROSOFT.FORECAST.ETS FORECAST.ETS.ADD sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts()
Add Excel 2016 function f336f6 2016-03-03 5.2 COM.MICROSOFT.FORECAST.ETS.CONFINT FORECAST.ETS.PI.ADD sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts()
Add Excel 2016 function f336f6 2016-03-03 5.2 COM.MICROSOFT.FORECAST.ETS.SEASONALITY FORECAST.ETS.SEASONALITY sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts()
Add Excel 2016 function f336f6 2016-03-03 5.2 COM.MICROSOFT.FORECAST.ETS.STAT FORECAST.ETS.STAT.ADD sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts()
Add Excel 2016 function f336f6 2016-03-03 5.2 COM.MICROSOFT.FORECAST.LINEAR FORECAST.LINEAR sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecast()
Add Excel 2016 function a76c5e 2016-04-26 5.2 COM.MICROSOFT.CONCAT CONCAT sc/source/core/tool/interpr8.cxx ScInterpreter::ScConcat_MS()
Add Excel 2016 function a76c5e 2016-04-26 5.2 COM.MICROSOFT.TEXTJOIN TEXTJOIN sc/source/core/tool/interpr8.cxx ScInterpreter::ScTextJoin_MS()
Add Excel 2016 function 29433 2016-05-03 5.2 COM.MICROSOFT.IFS IFS sc/source/core/tool/interpr8.cxx ScInterpreter::ScIfs_MS()
Add Excel 2016 function 29433 2016-05-03 5.2 COM.MICROSOFT.SWITCH SWITCH sc/source/core/tool/interpr1.cxx ScInterpreter::ScSwitch_MS()
Add Excel 2016 function c57dc741a6f221f53f3c8da2f521c6ece63246c2 2016-05-04 5.2 COM.MICROSOFT.MINIFS MINIFS sc/source/core/tool/interpr1.cxx ScInterpreter::ScMinIfs_MS()
Add Excel 2016 function c57dc741a6f221f53f3c8da2f521c6ece63246c2 2016-05-04 5.2 COM.MICROSOFT.MAXIFS MAXIFS sc/source/core/tool/interpr1.cxx ScInterpreter::ScMaxIfs_MS()
Add Excel 2021 function f7039822c7ad3987326e1c20ea4a745c158f9682 2024-01-31 24.8 COM.MICROSOFT.XLOOKUP XLOOKUP sc/source/core/tool/interpr1.cxx ScInterpreter::ScXLookup()
Add Excel 2021 function b36ecef07a4933c0943b27ea937f31e1df2e77cd 2024-02-18 24.8 COM.MICROSOFT.XMATCH XMATCH sc/source/core/tool/interpr1.cxx ScInterpreter::ScXMatch()
Add Excel 2021 function b0791dd9216224bdb266fd0d8c87df253b6d0583 2024-03-01 24.8 COM.MICROSOFT.FILTER FILTER sc/source/core/tool/interpr1.cxx ScInterpreter::ScFilter()
Add Excel 2021 function 45435a680be065e44eba385bb2523b27b77fb451 2024-03-25 24.8 COM.MICROSOFT.SORT SORT sc/source/core/tool/interpr1.cxx ScInterpreter::ScSort()
Add Excel 2021 function bfb4c58ae708c75949559290bdfdd9afcef6aa91 2024-03-26 24.8 COM.MICROSOFT.SORTBY SORTBY sc/source/core/tool/interpr1.cxx ScInterpreter::ScSortBy()
Add Excel 2021 function 35772a003bb30be61f8ba8abe805455e41db0e1e 2024-04-26 24.8 COM.MICROSOFT.SEQUENCE SEQUENCE sc/source/core/tool/interpr5.cxx ScInterpreter::ScMatSequence()
Add Excel 2021 function d68f2394afc3372d867ea6157123e51b278ba81b 2024-05-08 24.8 COM.MICROSOFT.RANDARRAY RANDARRAY sc/source/core/tool/interpr1.cxx ScInterpreter::ScRandArray()
Add Excel 2021 function c1565b8b94548ef85508b0302ef9299f18ff09be 2024-05-15 24.8 COM.MICROSOFT.UNIQUE UNIQUE sc/source/core/tool/interpr1.cxx ScInterpreter::ScUnique()
Add Excel 2021 function 521a56d8d1e12b7471fda6b62b21d51776c9fbaf 2024-06-06 24.8 COM.MICROSOFT.LET LET sc/source/core/tool/interpr1.cxx ScInterpreter::ScLet()

Namespace: COM.SUN.STAR.SHEET.ADDIN

Commit Added to master Affects LO Versions Full Name

(with Namespace)

Function name in UI Code pointer Description Notes OASIS cross-reference Standardized in ODFF Standardized as...
Appears in e9f31e 2012-12-04 4.0 COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER OPT_BARRIER scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptBarrier() Pricing of a barrier option.
Appears in e9f31e 2012-12-04 4.0 COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT OPT_PROB_HIT scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptProbHit() Probability that an asset hits a barrier.
Appears in e9f31e 2012-12-04 4.0 COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY OPT_PROB_INMONEY scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptProbInMoney() Probability that an asset will at maturity end up between two barrier levels.
Appears in e9f31e 2012-12-04 4.0 COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH OPT_TOUCH scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptTouch() Pricing of a touch/no-touch option.