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()

    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.