Development/ODF Implementer Notes/List of LibreOffice OpenFormula Extensions

    From The Document Foundation Wiki

    TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

    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.
    Retrieved from "https://wiki.documentfoundation.org/index.php?title=Development/ODF_Implementer_Notes/List_of_LibreOffice_OpenFormula_Extensions&oldid=753375"