# ODF Implementer Notes: List of Collabora OpenFormula Extensions

This page contains a list of all **Collabora OpenFormula Extensions**
-- functions that we've added to Collabora Online and Collabora Office
to extend what's available in the OpenFormula specification.

## Collabora 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 Collabora Online
and Collabora Office.

## 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](https://cgit.collaboraoffice.com/c/core/commit/?id=dd0f844728a53a337233a3c687b792e725803da5) | 2014-05-19 | 4.4 |  [ORG.LIBREOFFICE.COLOR](#ORG.LIBREOFFICE.COLOR) | COLOR | sc/source/core/tool/interpr7.cxx ScInterpreter::ScColor() | Returns an ARGB value. |  |  |  |  |
| OPCODE appears in [db1e34](https://cgit.collaboraoffice.com/c/core/commit/?id=db1e34aecd4290623a74b9bbeb602e072b1a49ec) | 2015-12-16 | 5.2 |  [ORG.LIBREOFFICE.RAWSUBTRACT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [ORG.LIBREOFFICE.FORECAST.ETS.MULT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [ORG.LIBREOFFICE.FORECAST.ETS.PI.MULT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [ORG.LIBREOFFICE.FORECAST.ETS.STAT.MULT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=902c593196741ffec2d096855369313f6bbe756e) | 2016-01-05 | 5.1 |  [ORG.LIBREOFFICE.WEEKNUM_OOO](#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](https://bugs.documentfoundation.org/show_bug.cgi?id=50950) |  |  |  |  |
| OPCODE appears in [3ee1c4](https://cgit.collaboraoffice.com/c/core/commit/?id=3ee1c41ac72aaae9f364708b1c4df58d7643a341) | 2017-02-20 | 5.4 |  [ORG.LIBREOFFICE.ROUNDSIG](#ORG.LIBREOFFICE.ROUNDSIG) | ROUNDSIG | sc/source/core/tool/interpr2.cxx ScInterpreter::ScRoundSignificant() | Return value in specified number of significant digits, see [tdf#105931](https://bugs.documentfoundation.org/show_bug.cgi?id=105931) |  |  |  |  |
| OPCODE appears in [8dec85](https://cgit.collaboraoffice.com/c/core/commit/?id=8dec85a3b3f4cbd46b03f707458347a25cc22c15) | 2018-10-25 | 6.2 |  [ORG.LIBREOFFICE.REGEX](#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](https://bugs.documentfoundation.org/show_bug.cgi?id=113977) |  |  |  |  |
| OPCODE appears in [32d9f7](https://cgit.collaboraoffice.com/c/core/commit/?id=32d9f7a632e1df1b6d5ac32a88b2b88c042e91ff) | 2019-02-16 | 6.3 |  [ORG.LIBREOFFICE.FOURIER](#ORG.LIBREOFFICE.FOURIER) | FOURIER | sc/source/core/tool/interpr3.cxx ScInterpreter::ScFourier() | Calculates Fourier analysis, see [tdf#74664](https://bugs.documentfoundation.org/show_bug.cgi?id=74664) |  |  |  |  |
| OPCODE appears in [716655](https://cgit.collaboraoffice.com/c/core/commit/?id=716655820d69a0d6aaa2714cb4f12bae1aa2b862) | 2020-04-28 | 7.0 |  [ORG.LIBREOFFICE.RAND.NV](#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](https://bugs.documentfoundation.org/show_bug.cgi?id=127831) |  |  |  |  |
| OPCODE appears in [716655](https://cgit.collaboraoffice.com/c/core/commit/?id=716655820d69a0d6aaa2714cb4f12bae1aa2b862) | 2020-04-28 | 7.0 |  [ORG.LIBREOFFICE.RANDBETWEEN.NV](#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](https://bugs.documentfoundation.org/show_bug.cgi?id=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](https://cgit.collaboraoffice.com/c/core/commit/?id=2cb4c646a81c92d7582c0db6eedeb09128ace1c5) | 2009-01-08 | All |  [ORG.OPENOFFICE.CURRENT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=18e75834e72fe82baab3a4c5141bacd36f3b9c81) | 2008-07-22 | All |  [ORG.OPENOFFICE.ERRORTYPE](#ORG.OPENOFFICE.ERRORTYPE) | ERRORTYPE | sc/source/core/tool/interpr1.cxx ScInterpreter::ScErrorType() | Returns the internal error number. | This is **not** the [ERROR.TYPE](http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018364_715980110) function as defined by ODFF. |  |  |  |
| OPCODE appears in [2cb4c6](https://cgit.collaboraoffice.com/c/core/commit/?id=2cb4c646a81c92d7582c0db6eedeb09128ace1c5) | 2009-01-08 | All |  [ORG.OPENOFFICE.MULTIRANGE](#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)](http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018036_715980110) |
| OPCODE appears in [2cb4c6](https://cgit.collaboraoffice.com/c/core/commit/?id=2cb4c646a81c92d7582c0db6eedeb09128ace1c5) | 2009-01-08 | All |  [ORG.OPENOFFICE.STYLE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=2cb4c646a81c92d7582c0db6eedeb09128ace1c5) Clarified vs CONVERT_ADD in [830249](https://cgit.collaboraoffice.com/c/core/commit/?id=8302495a219e869f194f4b585c6f2b996eee0a5c) | 2009-01-08 2013-12-02 | All |  [ORG.OPENOFFICE.CONVERT](#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](http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018496_715980110) function as defined by ODFF (which in the UI is CONVERT_ADD for historical reasons). |  |  |  |
| OPCODE appears in [2cb4c6](https://cgit.collaboraoffice.com/c/core/commit/?id=2cb4c646a81c92d7582c0db6eedeb09128ace1c5) Write correct name [3deb83](https://cgit.collaboraoffice.com/c/core/commit/?id=3deb83d7a74a0fe026791e7a336ac6ffad9c0026) | 2009-01-08 2011-12-07 | All |  [ORG.OPENOFFICE.EASTERSUNDAY](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.WEEKS](#ORG.OPENOFFICE.WEEKS) | WEEKS | scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffWeeks() | Calculates the number of weeks in a specific period. |  |  |  |  |
| Name appears [b785f9](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.MONTHS](#ORG.OPENOFFICE.MONTHS) | MONTHS | scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffMonths() | Calculates the number of months in a specific period. |  |  |  |  |
| Name appears [b785f9](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.YEARS](#ORG.OPENOFFICE.YEARS) | YEARS | scaddins/source/datefunc/datefunc.cxx ScaDateAddIn::getDiffYears() | Calculates the number of years in a specific period. |  |  |  |  |
| Name appears [b785f9](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.ISLEAPYEAR](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.DAYSINMONTH](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.DAYSINYEAR](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.WEEKSINYEAR](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=b785f925276b05e49cb84f20991fae6cf1aba9cf) Func not in ODF or Excel [27aeea](https://cgit.collaboraoffice.com/c/core/commit/?id=27aeea8e2bd374ec2f7317ac485315118ea1feee) | 2008-01-10 2013-08-14 | All |  [ORG.OPENOFFICE.ROT13](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=3edfc3d3c9e5a10124923bd6733051efda287f51) | 2008-01-10 | All |  [COM.MICROSOFT.BAHTTEXT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=24bce470788aa34e5e1bb001250bfa14cee1c75e) Full name used [a21b79](https://cgit.collaboraoffice.com/c/core/commit/?id=a21b793383d8484a95f695d2f708600b471b8a4b) | 2013-01-31 2013-08-14 | 4.1 4.2 |  [COM.MICROSOFT.WEBSERVICE](#COM.MICROSOFT.WEBSERVICE) | WEBSERVICE |  |  |  |  |  |  |  |
| New Excel 2013 functions [24bce4](https://cgit.collaboraoffice.com/c/core/commit/?id=24bce470788aa34e5e1bb001250bfa14cee1c75e) Full name used [a21b79](https://cgit.collaboraoffice.com/c/core/commit/?id=a21b793383d8484a95f695d2f708600b471b8a4b) | 2013-01-31 2013-08-14 | 4.1 4.2 |  [COM.MICROSOFT.FILTERXML](#COM.MICROSOFT.FILTERXML) | FILTERXML |  |  |  |  |  |  |  |
| Add Excel 2010 Functions [6d2f42](https://cgit.collaboraoffice.com/c/core/commit/?id=6d2f42199c2a9b48c9e19d7ae087f5452bfbd401) | 2013-10-31 | 4.2 |  [COM.MICROSOFT.BETA.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=6d2f42199c2a9b48c9e19d7ae087f5452bfbd401) | 2013-10-31 | 4.2 |  [COM.MICROSOFT.BETA.INV](#COM.MICROSOFT.BETA.INV) | BETA.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScBetaInv() | Same as BETAINV |  |  |  |  |  |
| Add Excel 2010 Functions [e362bc](https://cgit.collaboraoffice.com/c/core/commit/?id=e362bc7892e0fd193e541838be4bd26b7ff42fdd) | 2013-11-04 | 4.2 |  [COM.MICROSOFT.BINOM.DIST](#COM.MICROSOFT.BINOM.DIST) | BINOM.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScBinomDist() | Same as BINOMDIST |  |  |  |  |  |
| Add Excel 2010 Functions [e362bc](https://cgit.collaboraoffice.com/c/core/commit/?id=e362bc7892e0fd193e541838be4bd26b7ff42fdd) | 2013-11-04 | 4.2 |  [COM.MICROSOFT.BINOM.INV](#COM.MICROSOFT.BINOM.INV) | BINOM.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScCritBinom() | Same as BINOMINV and CRITBINOM |  |  |  |  |  |
| Add support for function [ccbebd](https://cgit.collaboraoffice.com/c/core/commit/?id=ccbebd991b6bbce30d10b88f464140338f706c5b) | 2013-10-18 | 4.2 |  [COM.MICROSOFT.COVARIANCE.P](#COM.MICROSOFT.COVARIANCE.P) | COVARIANCE.P | sc/source/core/tool/interpr3.cxx ScInterpreter::ScCovarianceP() | Same as COVAR |  |  |  |  |  |
| Add support for function [ccbebd](https://cgit.collaboraoffice.com/c/core/commit/?id=ccbebd991b6bbce30d10b88f464140338f706c5b) | 2013-10-18 | 4.2 |  [COM.MICROSOFT.COVARIANCE.S](#COM.MICROSOFT.COVARIANCE.S) | COVARIANCE.S | sc/source/core/tool/interpr3.cxx ScInterpreter::ScCovarianceS() | Returns the sample covariance |  |  |  |  |  |
| Add support for function [4a122d](https://cgit.collaboraoffice.com/c/core/commit/?id=4a122d1e61278debe7e386e3d9f442e68eddba9b) | 2013-10-25 | 4.2 |  [COM.MICROSOFT.STDEV.P](#COM.MICROSOFT.STDEV.P) | STDEV.P | sc/source/core/tool/interpr3.cxx ScInterpreter::ScStDevP() | Same as STDEVP |  |  |  |  |  |
| Add support for function [4a122d](https://cgit.collaboraoffice.com/c/core/commit/?id=4a122d1e61278debe7e386e3d9f442e68eddba9b) | 2013-10-25 | 4.2 |  [COM.MICROSOFT.STDEV.S](#COM.MICROSOFT.STDEV.S) | STDEV.S | sc/source/core/tool/interpr3.cxx ScInterpreter::ScStDev() | Same as STDEV |  |  |  |  |  |
| [781363](https://cgit.collaboraoffice.com/c/core/commit/?id=781363934af5c0ff3401161c385c6c93c9352c2c) | 2013-10-30 | 4.2 |  [COM.MICROSOFT.VAR.P](#COM.MICROSOFT.VAR.P) | VAR.P | sc/source/core/tool/interpr3.cxx ScInterpreter::ScVarP() | Same as VARP |  |  |  |  |  |
| [781363](https://cgit.collaboraoffice.com/c/core/commit/?id=781363934af5c0ff3401161c385c6c93c9352c2c) | 2013-10-30 | 4.2 |  [COM.MICROSOFT.VAR.S](#COM.MICROSOFT.VAR.S) | VAR.S | sc/source/core/tool/interpr3.cxx ScInterpreter::ScVar() | Same as VAR |  |  |  |  |  |
| [756015](https://cgit.collaboraoffice.com/c/core/commit/?id=75601529a807f15fa648c22e3636281981cd7623) | 2013-11-08 | 4.2 |  [COM.MICROSOFT.CHISQ.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=75601529a807f15fa648c22e3636281981cd7623) | 2013-11-08 | 4.2 |  [COM.MICROSOFT.CHISQ.INV](#COM.MICROSOFT.CHISQ.INV) | CHISQ.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiSqInv() | Same as CHISQINV |  |  |  |  |  |
| [756015](https://cgit.collaboraoffice.com/c/core/commit/?id=75601529a807f15fa648c22e3636281981cd7623) | 2013-11-08 | 4.2 |  [COM.MICROSOFT.CHISQ.TEST](#COM.MICROSOFT.CHISQ.TEST) | CHISQ.TEST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiSqTest() | Same as CHISQTEST |  |  |  |  |  |
| [756015](https://cgit.collaboraoffice.com/c/core/commit/?id=75601529a807f15fa648c22e3636281981cd7623) | 2013-11-08 | 4.2 |  [COM.MICROSOFT.CHISQ.DIST.RT](#COM.MICROSOFT.CHISQ.DIST.RT) | CHISQ.DIST.RT | sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiDist() | Same as LEGACY.CHIDIST |  |  |  |  |  |
| [756015](https://cgit.collaboraoffice.com/c/core/commit/?id=75601529a807f15fa648c22e3636281981cd7623) | 2013-11-08 | 4.2 |  [COM.MICROSOFT.CHISQ.INV.RT](#COM.MICROSOFT.CHISQ.INV.RT) | CHISQ.INV.RT | sc/source/core/tool/interpr3.cxx ScInterpreter::ScChiInv() | Same as LEGACY.CHIINV |  |  |  |  |  |
| [53b2d2](https://cgit.collaboraoffice.com/c/core/commit/?id=53b2d2ce0c68cd371fb55c8fdbab47a4075bbe8e) | 2013-11-14 | 4.2 |  [COM.MICROSOFT.CONFIDENCE.NORM](#COM.MICROSOFT.CONFIDENCE.NORM) | CONFIDENCE.NORM | sc/source/core/tool/interpr3.cxx ScInterpreter::ScConfidence() | Same as CONFIDENCE |  |  |  |  |  |
| [53b2d2](https://cgit.collaboraoffice.com/c/core/commit/?id=53b2d2ce0c68cd371fb55c8fdbab47a4075bbe8e) | 2013-11-14 | 4.2 |  [COM.MICROSOFT.CONFIDENCE.T](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e434c1ce0557454ef4cdd98435c5c0b1d5181bcf) | 2013-11-22 | 4.2 |  [COM.MICROSOFT.EXPON.DIST](#COM.MICROSOFT.EXPON.DIST) | EXPON.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScExpDist() | Same as EXPONDIST |  |  |  |  |  |
| [5a1fa5](https://cgit.collaboraoffice.com/c/core/commit/?id=5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164) | 2013-11-20 | 4.2 |  [COM.MICROSOFT.F.DIST](#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](http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#__RefHeading__1018496_715980110) as defined by ODFF |  |  |  |  |  |
| [5a1fa5](https://cgit.collaboraoffice.com/c/core/commit/?id=5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164) | 2013-11-20 | 4.2 |  [COM.MICROSOFT.F.DIST.RT](#COM.MICROSOFT.F.DIST.RT) | F.DIST.RT | sc/source/core/tool/interpr3.cxx ScInterpreter::ScFDist() | Same as FDIST |  |  |  |  |  |
| [5a1fa5](https://cgit.collaboraoffice.com/c/core/commit/?id=5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164) | 2013-11-20 | 4.2 |  [COM.MICROSOFT.F.INV](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164) | 2013-11-20 | 4.2 |  [COM.MICROSOFT.F.INV.RT](#COM.MICROSOFT.F.INV.RT) | F.INV.RT | sc/source/core/tool/interpr3.cxx ScInterpreter::ScFInv() | Same as FINV |  |  |  |  |  |
| [5a1fa5](https://cgit.collaboraoffice.com/c/core/commit/?id=5a1fa549520aad341b1b8cfe59b1e1b6ed3e4164) | 2013-11-20 | 4.2 |  [COM.MICROSOFT.F.TEST](#COM.MICROSOFT.F.TEST) | F.TEST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScFTest() | Same as FTEST |  |  |  |  |  |
| [853903](https://cgit.collaboraoffice.com/c/core/commit/?id=8539039e0c108da7d0306c37962415ce7e271c84) | 2013-11-29 | 4.2 |  [COM.MICROSOFT.GAMMA.DIST](#COM.MICROSOFT.GAMMA.DIST) | GAMMA.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScGammaDist() | Differs from GAMMADIST: cumulative is required |  |  |  |  |  |
| [853903](https://cgit.collaboraoffice.com/c/core/commit/?id=8539039e0c108da7d0306c37962415ce7e271c84) | 2013-11-29 | 4.2 |  [COM.MICROSOFT.GAMMA.INV](#COM.MICROSOFT.GAMMA.INV) | GAMMA.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScGammaInv() | Same as GAMMAINV |  |  |  |  |  |
| [853903](https://cgit.collaboraoffice.com/c/core/commit/?id=8539039e0c108da7d0306c37962415ce7e271c84) | 2013-11-29 | 4.2 |  [COM.MICROSOFT.GAMMALN.PRECISE](#COM.MICROSOFT.GAMMALN.PRECISE) | GAMMALN.PRECISE | sc/source/core/tool/interpr3.cxx ScInterpreter::ScLogGamma() | Same as GAMMALN |  |  |  |  |  |
| [e434c1](https://cgit.collaboraoffice.com/c/core/commit/?id=e434c1ce0557454ef4cdd98435c5c0b1d5181bcf) | 2013-11-22 | 4.2 |  [COM.MICROSOFT.HYPGEOM.DIST](#COM.MICROSOFT.HYPGEOM.DIST) | HYPGEOM.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScHypGeomDist_MS() | Differs from HYPGEOMDIST: extra argument cumulative (required) |  |  |  |  |  |
| [e434c1](https://cgit.collaboraoffice.com/c/core/commit/?id=e434c1ce0557454ef4cdd98435c5c0b1d5181bcf) | 2013-11-22 | 4.2 |  [COM.MICROSOFT.POISSON.DIST](#COM.MICROSOFT.POISSON.DIST) | POISSON.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScPoissonDist() | Same as POISSONDIST |  |  |  |  |  |
| [e434c1](https://cgit.collaboraoffice.com/c/core/commit/?id=e434c1ce0557454ef4cdd98435c5c0b1d5181bcf) | 2013-11-22 | 4.2 |  [COM.MICROSOFT.WEIBULL.DIST](#COM.MICROSOFT.WEIBULL.DIST) | WEIBULL.DIST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScWeibull() | Same as WEIBULL |  |  |  |  |  |
| Add Excel 2010 function [924f9d](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.LOGNORM.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.LOGNORM.INV](#COM.MICROSOFT.LOGNORM.INV) | LOGNORM.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScLogNormInv() | Same as LOGNORMINV |  |  |  |  |  |
| Add Excel 2010 function [924f9d](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.NORM.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.NORM.INV](#COM.MICROSOFT.NORM.INV) | NORM.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScNormInv() | Same as NORMINV |  |  |  |  |  |
| Add Excel 2010 function [924f9d](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.NORM.S.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=924f9d7ea89899848dba512a428e5f64e44ee534) | 2013-12-16 | 4.2 |  [COM.MICROSOFT.NORM.S.INV](#COM.MICROSOFT.NORM.S.INV) | NORM.S.INV | sc/source/core/tool/interpr3.cxx ScInterpreter::ScSNormInv() | Same as NORMSINV |  |  |  |  |  |
| Add Excel 2010 function [5b1e44](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.DIST.2T](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.DIST.RT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.INV](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.INV.2T](#COM.MICROSOFT.T.INV.2T) | T.INV.2T | sc/source/core/tool/interpr3.cxx ScInterpreter::ScTInv() | Same as TINV |  |  |  |  |  |
| Add Excel 2010 function [5b1e44](https://cgit.collaboraoffice.com/c/core/commit/?id=5b1e440304c271e4286255c17a6fe475899bd94f) | 2014-01-27 | 4.3 |  [COM.MICROSOFT.T.TEST](#COM.MICROSOFT.T.TEST) | T.TEST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScTTest() | Same as TTEST |  |  |  |  |  |
| [8185ec](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.PERCENTILE.INC](#COM.MICROSOFT.PERCENTILE.INC) | PERCENTILE.INC | sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentile() | Same as PERCENTILE |  |  |  |  |  |
| [8185ec](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.PERCENTRANK.INC](#COM.MICROSOFT.PERCENTRANK.INC) | PERCENTRANK.INC | sc/source/core/tool/interpr3.cxx ScInterpreter::ScPercentrank() | Same as PERCENTRANK |  |  |  |  |  |
| [8185ec](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.QUARTILE.INC](#COM.MICROSOFT.QUARTILE.INC) | QUARTILE.INC | sc/source/core/tool/interpr3.cxx ScInterpreter::ScQuartile() | Same as QUARTILE |  |  |  |  |  |
| [8185ec](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.RANK.EQ](#COM.MICROSOFT.RANK.EQ) | RANK.EQ | sc/source/core/tool/interpr3.cxx ScInterpreter::ScRank() | Same as RANK |  |  |  |  |  |
| [8185ec](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.PERCENTILE.EXC](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.PERCENTRANK.EXC](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.QUARTILE.EXC](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=8185ecf65addcd0c10eda6863a849e39b93684d3) | 2014-01-30 | 4.3 |  [COM.MICROSOFT.RANK.AVG](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e4def6edaa4686e50bbfd4490a4b9ddb928397a4) | 2014-03-05 | 4.3 |  [COM.MICROSOFT.MODE.SNGL](#COM.MICROSOFT.MODE.SNGL) | MODE.SNGL | sc/source/core/tool/interpr3.cxx ScInterpreter::ScModalValue() | Same as MODE |  |  |  |  |  |
| [e4def6](https://cgit.collaboraoffice.com/c/core/commit/?id=e4def6edaa4686e50bbfd4490a4b9ddb928397a4) | 2014-03-05 | 4.3 |  [COM.MICROSOFT.MODE.MULT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e4def6edaa4686e50bbfd4490a4b9ddb928397a4) | 2014-03-05 | 4.3 |  [COM.MICROSOFT.NEGBINOM.DIST](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e4def6edaa4686e50bbfd4490a4b9ddb928397a4) | 2014-03-05 | 4.3 |  [COM.MICROSOFT.Z.TEST](#COM.MICROSOFT.Z.TEST) | Z.TEST | sc/source/core/tool/interpr3.cxx ScInterpreter::ScZTest() | Same as ZTEST |  |  |  |  |  |
| [ed7782](https://cgit.collaboraoffice.com/c/core/commit/?id=ed778238375b45d3d1fb384ed3c78ce250f1c28d) | 2014-03-10 | 4.3 |  [COM.MICROSOFT.ISO.CEILING](#COM.MICROSOFT.ISO.CEILING) | ISO.CEILING | sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeiling_MS() | Same as CEILING.PRECISE |  |  |  |  |  |
| [ed7782](https://cgit.collaboraoffice.com/c/core/commit/?id=ed778238375b45d3d1fb384ed3c78ce250f1c28d) | 2014-03-10 | 4.3 |  [COM.MICROSOFT.CEILING.PRECISE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=ed778238375b45d3d1fb384ed3c78ce250f1c28d) | 2014-03-10 | 4.3 |  [COM.MICROSOFT.FLOOR.PRECISE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=010b2d2d9be846fb6b10848204e29e1bc00ef1ea) | 2015-04-29 | 5.0 |  [COM.MICROSOFT.CEILING.MATH](#COM.MICROSOFT.CEILING.MATH) | CEILING.MATH | sc/source/core/tool/interpr2.cxx ScInterpreter::ScCeil() |  |  |  |  |  |  |
| [010b2d](https://cgit.collaboraoffice.com/c/core/commit/?id=010b2d2d9be846fb6b10848204e29e1bc00ef1ea) | 2015-04-29 | 5.0 |  [COM.MICROSOFT.CEILING](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=cb13c46da1cdd1e2b95fd473cc0ff54f776dfe9c) | 2015-06-11 | 5.0 |  [COM.MICROSOFT.FLOOR](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=cb13c46da1cdd1e2b95fd473cc0ff54f776dfe9c) | 2015-06-11 | 5.0 |  [COM.MICROSOFT.FLOOR.MATH](#COM.MICROSOFT.FLOOR.MATH) | FLOOR.MATH | sc/source/core/tool/interpr2.cxx ScInterpreter::ScFloor_Math() |  |  |  |  |  |  |
| [cb13c4](https://cgit.collaboraoffice.com/c/core/commit/?id=cb13c46da1cdd1e2b95fd473cc0ff54f776dfe9c) | 2015-06-11 | 5.0 |  [COM.MICROSOFT.FLOOR.PRECISE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=22dac22fe256b28b78c8e0783f2625aee0f75ace) | 2014-04-02 | 4.3 |  [COM.MICROSOFT.NETWORKDAYS.INTL](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=22dac22fe256b28b78c8e0783f2625aee0f75ace) | 2014-04-02 | 4.3 |  [COM.MICROSOFT.WORKDAY.INTL](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=56deaabb32346e0cc9c6946d7d53ba251f4450b2) | 2014-04-11 | 4.3 |  [COM.MICROSOFT.ERF.PRECISE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=56deaabb32346e0cc9c6946d7d53ba251f4450b2) | 2014-04-11 | 4.3 |  [COM.MICROSOFT.ERFC.PRECISE](#COM.MICROSOFT.ERFC.PRECISE) | ERFC.PRECISE | sc/source/core/tool/interpr7.cxx ScInterpreter::ScErfc_MS() | Same as ERFC |  |  |  |  |  |
| Add Excel 2010 function [29c971](https://cgit.collaboraoffice.com/c/core/commit/?id=29c9712b042e410e93e92dead15f353f6ca1e263) | 2014-04-25 | 4.3 |  [COM.MICROSOFT.AGGREGATE](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=56deaabb32346e0cc9c6946d7d53ba251f4450b2) [9266ab](https://cgit.collaboraoffice.com/c/core/commit/?id=9266abdb548ce99ebd891080fa263e930c5234e1) | 2015-01-26 | 5.0 |  [COM.MICROSOFT.ENCODEURL](#COM.MICROSOFT.ENCODEURL) | ENCODEURL | sc/source/core/tool/interpr7.cxx ScInterpreter::ScEncodeURL() |  |  |  |  |  |  |
| Add Excel 2016 function [f336f6](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [COM.MICROSOFT.FORECAST.ETS](#COM.MICROSOFT.FORECAST.ETS) | FORECAST.ETS.ADD | sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() |  |  |  |  |  |  |
| Add Excel 2016 function [f336f6](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [COM.MICROSOFT.FORECAST.ETS.CONFINT](#COM.MICROSOFT.FORECAST.ETS.CONFINT) | FORECAST.ETS.PI.ADD | sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() |  |  |  |  |  |  |
| Add Excel 2016 function [f336f6](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [COM.MICROSOFT.FORECAST.ETS.SEASONALITY](#COM.MICROSOFT.FORECAST.ETS.SEASONALITY) | FORECAST.ETS.SEASONALITY | sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() |  |  |  |  |  |  |
| Add Excel 2016 function [f336f6](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [COM.MICROSOFT.FORECAST.ETS.STAT](#COM.MICROSOFT.FORECAST.ETS.STAT) | FORECAST.ETS.STAT.ADD | sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecastEts() |  |  |  |  |  |  |
| Add Excel 2016 function [f336f6](https://cgit.collaboraoffice.com/c/core/commit/?id=f336f63da900d76c2bf6e5690f1c8a7bd15a0aa2) | 2016-03-03 | 5.2 |  [COM.MICROSOFT.FORECAST.LINEAR](#COM.MICROSOFT.FORECAST.LINEAR) | FORECAST.LINEAR | sc/source/core/tool/interpr8.cxx ScInterpreter::ScForecast() |  |  |  |  |  |  |
| Add Excel 2016 function [a76c5e](https://cgit.collaboraoffice.com/c/core/commit/?id=a76c5e21378e5364f1f7554a32d89072feff8b0c) | 2016-04-26 | 5.2 |  [COM.MICROSOFT.CONCAT](#COM.MICROSOFT.CONCAT) | CONCAT | sc/source/core/tool/interpr8.cxx ScInterpreter::ScConcat_MS() |  |  |  |  |  |  |
| Add Excel 2016 function [a76c5e](https://cgit.collaboraoffice.com/c/core/commit/?id=a76c5e21378e5364f1f7554a32d89072feff8b0c) | 2016-04-26 | 5.2 |  [COM.MICROSOFT.TEXTJOIN](#COM.MICROSOFT.TEXTJOIN) | TEXTJOIN | sc/source/core/tool/interpr8.cxx ScInterpreter::ScTextJoin_MS() |  |  |  |  |  |  |
| Add Excel 2016 function [29433](https://cgit.collaboraoffice.com/c/core/commit/?id=29433c6496e8aa2d82ce56731d4bb734538a9f80) | 2016-05-03 | 5.2 |  [COM.MICROSOFT.IFS](#COM.MICROSOFT.IFS) | IFS | sc/source/core/tool/interpr8.cxx ScInterpreter::ScIfs_MS() |  |  |  |  |  |  |
| Add Excel 2016 function [29433](https://cgit.collaboraoffice.com/c/core/commit/?id=29433c6496e8aa2d82ce56731d4bb734538a9f80) | 2016-05-03 | 5.2 |  [COM.MICROSOFT.SWITCH](#COM.MICROSOFT.SWITCH) | SWITCH | sc/source/core/tool/interpr1.cxx ScInterpreter::ScSwitch_MS() |  |  |  |  |  |  |
| Add Excel 2016 function [c57dc741a6f221f53f3c8da2f521c6ece63246c2](https://cgit.collaboraoffice.com/c/core/commit/?id=c57dc741a6f221f53f3c8da2f521c6ece63246c2) | 2016-05-04 | 5.2 |  [COM.MICROSOFT.MINIFS](#COM.MICROSOFT.MINIFS) | MINIFS | sc/source/core/tool/interpr1.cxx ScInterpreter::ScMinIfs_MS() |  |  |  |  |  |  |
| Add Excel 2016 function [c57dc741a6f221f53f3c8da2f521c6ece63246c2](https://cgit.collaboraoffice.com/c/core/commit/?id=c57dc741a6f221f53f3c8da2f521c6ece63246c2) | 2016-05-04 | 5.2 |  [COM.MICROSOFT.MAXIFS](#COM.MICROSOFT.MAXIFS) | MAXIFS | sc/source/core/tool/interpr1.cxx ScInterpreter::ScMaxIfs_MS() |  |  |  |  |  |  |
| Add Excel 2021 function [f7039822c7ad3987326e1c20ea4a745c158f9682](https://cgit.collaboraoffice.com/c/core/commit/?id=f7039822c7ad3987326e1c20ea4a745c158f9682) | 2024-01-31 | 24.8 |  [COM.MICROSOFT.XLOOKUP](#COM.MICROSOFT.XLOOKUP) | XLOOKUP | sc/source/core/tool/interpr1.cxx ScInterpreter::ScXLookup() |  |  |  |  |  |  |
| Add Excel 2021 function [b36ecef07a4933c0943b27ea937f31e1df2e77cd](https://cgit.collaboraoffice.com/c/core/commit/?id=b36ecef07a4933c0943b27ea937f31e1df2e77cd) | 2024-02-18 | 24.8 |  [COM.MICROSOFT.XMATCH](#COM.MICROSOFT.XMATCH) | XMATCH | sc/source/core/tool/interpr1.cxx ScInterpreter::ScXMatch() |  |  |  |  |  |  |
| Add Excel 2021 function [b0791dd9216224bdb266fd0d8c87df253b6d0583](https://cgit.collaboraoffice.com/c/core/commit/?id=b0791dd9216224bdb266fd0d8c87df253b6d0583) | 2024-03-01 | 24.8 |  [COM.MICROSOFT.FILTER](#COM.MICROSOFT.FILTER) | FILTER | sc/source/core/tool/interpr1.cxx ScInterpreter::ScFilter() |  |  |  |  |  |  |
| Add Excel 2021 function [45435a680be065e44eba385bb2523b27b77fb451](https://cgit.collaboraoffice.com/c/core/commit/?id=45435a680be065e44eba385bb2523b27b77fb451) | 2024-03-25 | 24.8 |  [COM.MICROSOFT.SORT](#COM.MICROSOFT.SORT) | SORT | sc/source/core/tool/interpr1.cxx ScInterpreter::ScSort() |  |  |  |  |  |  |
| Add Excel 2021 function [bfb4c58ae708c75949559290bdfdd9afcef6aa91](https://cgit.collaboraoffice.com/c/core/commit/?id=bfb4c58ae708c75949559290bdfdd9afcef6aa91) | 2024-03-26 | 24.8 |  [COM.MICROSOFT.SORTBY](#COM.MICROSOFT.SORTBY) | SORTBY | sc/source/core/tool/interpr1.cxx ScInterpreter::ScSortBy() |  |  |  |  |  |  |
| Add Excel 2021 function [35772a003bb30be61f8ba8abe805455e41db0e1e](https://cgit.collaboraoffice.com/c/core/commit/?id=35772a003bb30be61f8ba8abe805455e41db0e1e) | 2024-04-26 | 24.8 |  [COM.MICROSOFT.SEQUENCE](#COM.MICROSOFT.SEQUENCE) | SEQUENCE | sc/source/core/tool/interpr5.cxx ScInterpreter::ScMatSequence() |  |  |  |  |  |  |
| Add Excel 2021 function [d68f2394afc3372d867ea6157123e51b278ba81b](https://cgit.collaboraoffice.com/c/core/commit/?id=d68f2394afc3372d867ea6157123e51b278ba81b) | 2024-05-08 | 24.8 |  [COM.MICROSOFT.RANDARRAY](#COM.MICROSOFT.RANDARRAY) | RANDARRAY | sc/source/core/tool/interpr1.cxx ScInterpreter::ScRandArray() |  |  |  |  |  |  |
| Add Excel 2021 function [c1565b8b94548ef85508b0302ef9299f18ff09be](https://cgit.collaboraoffice.com/c/core/commit/?id=c1565b8b94548ef85508b0302ef9299f18ff09be) | 2024-05-15 | 24.8 |  [COM.MICROSOFT.UNIQUE](#COM.MICROSOFT.UNIQUE) | UNIQUE | sc/source/core/tool/interpr1.cxx ScInterpreter::ScUnique() |  |  |  |  |  |  |
| Add Excel 2021 function [521a56d8d1e12b7471fda6b62b21d51776c9fbaf](https://cgit.collaboraoffice.com/c/core/commit/?id=521a56d8d1e12b7471fda6b62b21d51776c9fbaf) | 2024-06-06 | 24.8 |  [COM.MICROSOFT.LET](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e9f31eaa49f9494113e72deaf0fe079701844ea4) | 2012-12-04 | 4.0 |  [COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER](#COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTBARRIER) | OPT_BARRIER | scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptBarrier() | Pricing of a barrier option. |  |  |  |  |
| Appears in [e9f31e](https://cgit.collaboraoffice.com/c/core/commit/?id=e9f31eaa49f9494113e72deaf0fe079701844ea4) | 2012-12-04 | 4.0 |  [COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBHIT](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e9f31eaa49f9494113e72deaf0fe079701844ea4) | 2012-12-04 | 4.0 |  [COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTPROBINMONEY](#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](https://cgit.collaboraoffice.com/c/core/commit/?id=e9f31eaa49f9494113e72deaf0fe079701844ea4) | 2012-12-04 | 4.0 |  [COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH](#COM.SUN.STAR.SHEET.ADDIN.PRICINGFUNCTIONS.GETOPTTOUCH) | OPT_TOUCH | scaddins/source/pricing/pricing.cxx ScaPricingAddIn::getOptTouch() | Pricing of a touch/no-touch option. |  |  |  |  |

------------------------------------------------------------------------

## Footer

This page is based on a modified version of
[https://wiki.documentfoundation.org/index.php?title=Development/ODF_Implementer_Notes/List_of_LibreOffice_OpenFormula_Extensions&oldid=753375](https://wiki.documentfoundation.org/index.php?title=Development/ODF_Implementer_Notes/List_of_LibreOffice_OpenFormula_Extensions&oldid=753375)
and the Original Authors are: Balazs Varga, Ilmari Lauhakangas, Eike Rathke, Adolfo Jayme Barrientos, Winfried Donkers, Dennis Roczek and Robinson Tryon.

This page is licensed under the [Creative Commons Attribution-ShareAlike 3.0 Unported License](https://creativecommons.org/licenses/by-sa/3.0/legalcode.en). The original work has been modified.