Functions comparison of LibreOffice Calc and Numbers

    From The Document Foundation Wiki

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


    Numbers is the spreadsheet application of Apple's iWork office suite. The page compares the available functions between Apple's Numbers and LibreOffice Calc.

    The functions of Numbers were taken of the official documentations which can be accessed at apple.com (Numbers '09) and at the online help (for Numbers 4). All functions which are not available in LibreOffice Calc are tracked in tdf#97334.


    Work In Progress by Dennis Roczek (talk) 2016-10-23T15:15:24 (UTC) : Stuff with colorful cells are tested and either identical (handling) or marked with additional notes.

    Feel free to update / to help me with the list - especially with the statistics functions.

    Need to be done: update functions to LibreOffice 5.2 which had been added in the meantime (e.g. Forecasts functions).

    Test Numbers' Excel export - does it only exports the values or does it exports the functions with vendor-extensions like we do for OOXML and for ODF.


    Summary of comparison

    Function Group LibreOffice 5.0 Calc iWork Numbers '08 iWork Numbers '09 iWork Numbers 4.0
    Add-in 48 0 22 22
    Array 14 1 7 8
    Database 12 0 0 0
    Date&Time 34 14 23 23
    Duration 0 0 8 8
    Financial 64 27 38 38
    Information 21 4 4 4
    Logical 8 5 6 6
    Mathematical 81 47 53 54
    Spreadsheet 21 15 15 16
    Statistic 141 34 68
    Text 41 23 23 24
    Sum 485 168 262
    unique functions TBD 0 12: BASETONUM, DAYNAME, DUR2DAYS, DUR2HOURS, DUR2MILLISECONDS, DUR2MINUTES, DUR2SECONDS, DUR2WEEKS, DURATION, MONTHNAME, NUMTOBASE, STRIPDURATION 12+1: POLYNOMIAL
    improvements to other functions many, not counted 0 BIN2DEC, BIN2HEX, BIN2OCT, CONVERT_ADD, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX All functions from '09 + PLAINTEXT, INTERSECT.RANGES, UNION.RANGES


    Comparison of functions

    Functions which are identical, but have different names are sorted after LibreOffice naming. Green cells means that the functions work identical (including parameter).

    Function Group LibreOffice 5.0 Calc iWork Numbers '08 iWork Numbers '09 iWork Numbers v4.0
    Mathematical ABS ABS ABS
    Financial ACCRINT ACCRINT ACCRINT
    Financial ACCRINTM ACCRINTM ACCRINTM
    Mathematical ACOS ACOS ACOS
    Mathematical ACOSH ACOSH ACOSH
    Mathematical ACOT
    Mathematical ACOTH
    Spreadsheet ADDRESS ADDRESS[1] ADDRESS[1] ADDRESS
    Mathematical AGGREGATE
    Financial AMORDEGRC
    Financial AMORLINC
    Logical AND AND AND
    Text ARABIC
    Spreadsheet AREAS AREAS AREAS AREAS
    Text ASC
    Mathematical ASIN ASIN ASIN
    Mathematical ASINH ASINH ASINH
    Mathematical ATAN ATAN ATAN
    Mathematical ATAN2 ATAN2 ATAN2
    Mathematical ATANH ATANH ATANH
    Statistic AVEDEV AVEDEV AVEDEV AVEDEV
    Statistic AVERAGE AVERAGE AVERAGE AVERAGE
    Statistic AVERAGEA AVERAGEA AVERAGEA AVERAGEA
    Statistic AVERAGEIF No AVERAGEIF AVERAGEIF
    Statistic AVERAGEIFS No AVERAGEIFS AVERAGEIFS
    Statistic B
    Text BAHTTEXT
    Text BASE
    Add-in Partial[2] No BASETONUM BASETONUM
    Add-in BESSELI
    Add-in BESSELJ No BESSELJ BESSELJ
    Add-in BESSELK
    Add-in BESSELY No BESSELY BESSELY
    Statistic BETA.DIST
    Statistic BETA.INV
    Statistic BETADIST No BETADIST BETADIST
    Statistic BETAINV No BETAINV BETAINV
    Add-in BIN2DEC[3] No BIN2DEC BIN2DEC
    Add-in BIN2HEX[3] No BIN2HEX BIN2HEX
    Add-in BIN2OCT[3] No BIN2OCT BIN2OCT
    Statistic BINOM.DIST
    Statistic BINOM.INV
    Statistic BINOMDIST BINOMDIST
    Mathematical BITAND
    Mathematical BITLSHIFT
    Mathematical BITOR
    Mathematical BITRSHIFT
    Mathematical BITXOR
    Mathematical CEILING
    Mathematical CEILING.MATH
    Mathematical CEILING.PRECISE
    Mathematical CEILING.XCL CEILING CEILING
    Information CELL
    Text CHAR
    Statistic CHIDIST CHIDIST
    Statistic CHIINV CHIINV
    Statistic CHISQ.DIST
    Statistic CHISQ.DIST.RT
    Statistic CHISQ.INV
    Statistic CHISQ.INV.RT
    Statistic CHISQ.TEST
    Statistic CHISQDIST
    Statistic CHISQINV
    Statistic CHITEST CHITEST
    Spreadsheet CHOOSE CHOOSE CHOOSE CHOOSE
    Text CLEAN[4] CLEAN[4] CLEAN[4]
    Text CODE
    Mathematical COLOR
    Spreadsheet COLUMN COLUMN COLUMN COLUMN
    Spreadsheet COLUMNS COLUMNS COLUMNS COLUMNS
    Mathematical COMBIN COMBIN COMBIN COMBIN
    Mathematical COMBINA
    Add-in COMPLEX
    Text CONCATENATE CONCATENATE CONCATENATE
    Statistic CONFIDENCE CONFIDENCE CONFIDENCE
    Statistic CONFIDENCE.NORM
    Statistic CONFIDENCE.T
    Mathematical CONVERT
    Add-in CONVERT_ADD[5] No CONVERT[5] CONVERT[5]
    Statistic CORREL CORREL CORREL
    Mathematical COS COS COS
    Mathematical COSH COSH COSH
    Mathematical COT
    Mathematical COTH
    Statistic COUNT COUNT COUNT
    Statistic COUNTA COUNTA COUNTA
    Statistic COUNTBLANK COUNTBLANK COUNTBLANK
    Statistic COUNTIF COUNTIF COUNTIF
    Statistic COUNTIFS COUNTIFS
    Financial COUPDAYBS COUPDAYBS COUPDAYBS
    Financial COUPDAYS COUPDAYS COUPDAYS
    Financial COUPDAYSNC COUPDAYSNC COUPDAYSNC
    Financial COUPNCD
    Financial COUPNUM COUPNUM COUPNUM
    Financial COUPPCD
    Statistic COVAR COVAR COVAR
    Statistic COVARIANCE.P
    Statistic COVARIANCE.S
    Statistic CRITBINOM CRITBINOM
    Mathematical CSC
    Mathematical CSCH
    Financial CUMIPMT No CUMIPMT[6]
    Financial CUMIPMT
    Financial CUMPRINC No CUMPRINC[6]
    Financial CUMPRINC
    Information CURRENT
    Date&Time DATE DATE DATE DATE
    Date&Time DATEDIF DATEDIF DATEDIF DATEDIF
    Date&Time DATEVALUE[7] No DATEVALUE[7] DATEVALUE[7]
    Database DAVERAGE
    Date&Time DAY DAY DAY DAY
    Date&Time No No DAYNAME DAYNAME
    Date&Time DAYS
    Date&Time DAYS360 No DAYS360 DAYS360
    Date&Time DAYSINMONTH
    Date&Time DAYSINYEAR
    Financial DB DB DB
    Database DCOUNT
    Database DCOUNTA
    Financial DDB DDB DDB
    Spreadsheet DDE
    Add-in DEC2BIN[3] No DEC2BIN DEC2BIN
    Add-in DEC2HEX[3] No DEC2HEX DEC2HEX
    Add-in DEC2OCT[3] No DEC2OCT DEC2OCT
    Text DECIMAL
    Mathematical DEGREES DEGREES DEGREES
    Add-in DELTA No DELTA DELTA
    Statistic DEVSQ DEVSQ
    Database DGET
    Financial DISC DISC DISC
    Database DMAX
    Database DMIN
    Text DOLLAR DOLLAR DOLLAR
    Financial DOLLARDE
    Financial DOLLARFR
    Database DPRODUCT
    Database DSTDEV
    Database DSTDEVP
    Database DSUM
    Duration No No DUR2DAYS
    Duration No No DUR2HOURS
    Duration No No DUR2MILLISECONDS
    Duration No No DUR2MINUTES
    Duration No No DUR2SECONDS
    Duration No No DUR2WEEKS
    Duration No No DURATION[8]
    Financial DURATION[8] No No
    Financial DURATION_ADD No BONDDURATION
    Database DVAR
    Database DVARP
    Date&Time EASTERSUNDAY
    Date&Time EDATE[9] EDATE[9] EDATE[9] EDATE[9]
    Financial EFFECT_ADD
    Financial EFFECTIVE EFFECT
    Text ENCODEURL
    Date&Time EOMONTH[9] No EOMONTH[9] EOMONTH[9]
    Add-in ERF No ERF ERF
    Statistic ERF.PRECISE
    Add-in ERFC No ERFC ERFC
    Statistic ERFC.PRECISE
    Spreadsheet ERROR.TYPE
    Spreadsheet ERRORTYPE
    Mathematical EUROCONVERT
    Mathematical EVEN EVEN EVEN
    Text EXACT EXACT EXACT
    Mathematical EXP EXP EXP
    Statistic EXPON.DIST
    Statistic EXPONDIST EXPONDIST
    Statistic F.DIST
    Statistic F.DIST.RT
    Statistic F.INV
    Statistic F.INV.RT
    Statistic F.TEST
    Mathematical FACT FACT FACT
    Add-in FACTDOUBLE No FACTDOUBLE FACTDOUBLE
    Logical FALSE FALSE FALSE
    Statistic FDIST FDIST
    Text FILTERXML
    Text FIND FIND FIND
    Statistic FINV FINV
    Statistic FISHER
    Statistic FISHERINV
    Text FIXED FIXED FIXED
    Mathematical FLOOR
    Mathematical FLOOR.MATH
    Mathematical FLOOR.PRECISE
    Mathematical FLOOR.XCL FLOOR FLOOR
    Statistic FORECAST FORECAST FORECAST
    Information FORMULA
    Array FREQUENCY No FREQUENCY FREQUENCY
    Statistic FTEST
    Financial FV FV FV
    Financial FVSCHEDULE
    Statistic GAMMA
    Statistic GAMMA.DIST
    Statistic GAMMA.INV
    Statistic GAMMADIST GAMMADIST
    Statistic GAMMAINV GAMMAINV
    Statistic GAMMALN GAMMALN
    Statistic GAMMALN.PRECISE
    Statistic GAUSS
    Mathematical GCD GCD GCD
    Mathematical GCD_ADD
    Statistic GEOMEAN GEOMEAN
    Add-in GESTEP No GESTEP GESTEP
    Spreadsheet GETPIVOTDATA
    Array GROWTH
    Statistic HARMEAN HARMEAN
    Add-in HEX2BIN[3] No HEX2BIN HEX2BIN
    Add-in HEX2DEC[3] No HEX2DEC HEX2DEC
    Add-in HEX2OCT[3] No HEX2OCT HEX2OCT
    Spreadsheet HLOOKUP HLOOKUP HLOOKUP HLOOKUP
    Date&Time HOUR HOUR HOUR HOUR
    Spreadsheet HYPERLINK HYPERLINK HYPERLINK HYPERLINK
    Statistic HYPGEOM.DIST
    Statistic HYPGEOMDIST
    Logical IF IF IF IF
    Information IFERROR No IFERROR IFERROR
    Logical IFNA
    Add-in IMABS
    Add-in IMAGINARY
    Add-in IMARGUMENT
    Add-in IMCONJUGATE
    Add-in IMCOS
    Add-in IMCOSH
    Add-in IMCOT
    Add-in IMCSC
    Add-in IMCSCH
    Add-in IMDIV
    Add-in IMEXP
    Add-in IMLN
    Add-in IMLOG10
    Add-in IMLOG2
    Add-in IMPOWER
    Add-in IMPRODUCT
    Add-in IMREAL
    Add-in IMSEC
    Add-in IMSECH
    Add-in IMSIN
    Add-in IMSINH
    Add-in IMSQRT
    Add-in IMSUB
    Add-in IMSUM
    Add-in IMTAN
    Spreadsheet INDEX INDEX INDEX INDEX
    Spreadsheet INDIRECT INDIRECT[10] INDIRECT[10] INDIRECT
    Information INFO
    Mathematical INT INT INT
    Statistic INTERCEPT INTERCEPT INTERCEPT
    Spreadsheet Not needed Not needed Not needed INTERSECT.RANGES[11]
    Financial INTRATE No INTRATE
    Financial IPMT IPMT IPMT
    Financial IRR[12] IRR IRR
    Information ISBLANK ISBLANK ISBLANK
    Information ISERR
    Information ISERROR ISERROR ISERROR
    Information ISEVEN ISEVEN ISEVEN
    Information ISEVEN_ADD
    Information ISFORMULA
    Date&Time ISLEAPYEAR
    Information ISLOGICAL
    Information ISNA
    Information ISNONTEXT
    Information ISNUMBER
    Mathematical ISO.CEILING
    Information ISODD ISODD ISODD
    Information ISODD_ADD
    Financial ISPMT ISPMT ISPMT
    Information ISREF
    Information ISTEXT
    Text JIS
    Statistic KURT
    Statistic LARGE LARGE LARGE
    Mathematical LCM LCM LCM
    Mathematical LCM_ADD
    Text LEFT LEFT LEFT LEFT
    Text LEFTB
    Text LEN LEN LEN
    Text LENB
    Array LINEST LINEST LINEST
    Mathematical LN LN LN
    Mathematical LOG LOG LOG
    Mathematical LOG10 LOG10 LOG10
    Array LOGEST
    Statistic LOGINV LOGINV
    Statistic LOGNORM.DIST
    Statistic LOGNORM.INV
    Statistic LOGNORMDIST LOGNORMDIST
    Spreadsheet LOOKUP LOOKUP LOOKUP LOOKUP
    Text LOWER LOWER LOWER
    Spreadsheet MATCH MATCH MATCH MATCH
    Statistic MAX MAX MAX
    Statistic MAXA MAXA MAXA
    Array MDETERM
    Financial MDURATION No BONDMDURATION BONDMDURATION
    Statistic MEDIAN MEDIAN MEDIAN
    Text MID MID MID MID
    Text MIDB
    Statistic MIN MIN MIN
    Statistic MINA MINA MINA
    Date&Time MINUTE MINUTE MINUTE MINUTE
    Array MINVERSE
    Financial MIRR[12] MIRR MIRR
    Array MMULT
    Mathematical MOD MOD MOD
    Statistic MODE[13] MODE[13] MODE[13]
    Statistic MODE.MULT
    Statistic MODE.SNGL
    Date&Time MONTH MONTH MONTH MONTH
    Date&Time No No MONTHNAME MONTHNAME
    Date&Time MONTHS
    Mathematical MROUND MROUND MROUND
    Mathematical MULTINOMIAL No MULTINOMIAL
    Array MUNIT
    Information N
    Information NA
    Statistic NEGBINOM.DIST
    Statistic NEGBINOMDIST NEGBINOMDIST
    Date&Time NETWORKDAYS No NETWORKDAYS NETWORKDAYS
    Date&Time NETWORKDAYS_ADD
    Date&Time NETWORKDAYS.INTL
    Financial NOMINAL NOMINAL
    Financial NOMINAL_ADD
    Statistic NORM.DIST
    Statistic NORM.INV
    Statistic NORM.S.DIST
    Statistic NORM.S.INV
    Statistic NORMDIST NORMDIST
    Statistic NORMINV NORMINV
    Statistic NORMSDIST NORMSDIST
    Statistic NORMSINV NORMSINV
    Logical NOT NOT NOT NOT
    Date&Time NOW NOW NOW NOW
    Financial NPER NPER NPER NPER
    Financial NPV NPV NPV NPV
    Text NUMBERVALUE
    Add-in Partial[2] No NUMTOBASE NUMTOBASE
    Add-in OCT2BIN[3] No OCT2BIN OCT2BIN
    Add-in OCT2DEC[3] No OCT2DEC OCT2DEC
    Add-in OCT2HEX[3] No OCT2HEX OCT2HEX
    Mathematical ODD ODD ODD
    Financial ODDFPRICE
    Financial ODDFYIELD
    Financial ODDLPRICE
    Financial ODDLYIELD
    Spreadsheet OFFSET OFFSET OFFSET OFFSET
    Financial OPT_BARRIER
    Financial OPT_PROB_HIT
    Financial OPT_PROB_INMONEY
    Financial OPT_TOUCH
    Logical OR OR OR OR
    Statistic PEARSON
    Statistic PERCENTILE PERCENTILE PERCENTILE
    Statistic PERCENTILE.EXC
    Statistic PERCENTILE.INC
    Statistic PERCENTRANK PERCENTRANK
    Statistic PERCENTRANK.EXC
    Statistic PERCENTRANK.INC
    Statistic PERMUT PERMUT
    Statistic PERMUTATIONA
    Statistic PHI
    Mathematical PI PI PI
    Text Not needed No[14] No[15] PLAINTEXT[16]
    Financial PMT PMT PMT
    Statistic POISSON POISSON POISSON
    Statistic POISSON.DIST
    Statistic Partial Partial Partial POLYNOMIAL[17]
    Mathematical POWER POWER POWER
    Financial PPMT PPMT PPMT
    Financial PRICE PRICE PRICE
    Financial PRICEDISC PRICEDISC PRICEDISC
    Financial PRICEMAT PRICEMAT PRICEMAT
    Statistic PROB PROB PROB
    Mathematical PRODUCT PRODUCT PRODUCT
    Text PROPER[18] PROPER[18] PROPER[18] PROPER[18]
    Financial PV PV PV PV
    Statistic QUARTILE QUARTILE
    Statistic QUARTILE.EXC
    Statistic QUARTILE.INC
    Mathematical QUOTIENT QUOTIENT QUOTIENT
    Mathematical RADIANS RADIANS RADIANS
    Mathematical RAND RAND RAND
    Mathematical RANDBETWEEN RANDBETWEEN RANDBETWEEN
    Statistic RANK RANK RANK
    Statistic RANK.AVG
    Statistic RANK.EQ
    Financial RATE RATE RATE RATE
    Financial RECEIVED No RECEIVED RECEIVED
    Text REPLACE REPLACE REPLACE
    Text REPT REPT REPT REPT[19]
    Text RIGHT RIGHT RIGHT
    Text RIGHTB
    Text ROMAN ROMAN ROMAN
    Text ROT13
    Mathematical ROUND ROUND ROUND
    Mathematical ROUNDDOWN ROUNDDOWN ROUNDDOWN
    Mathematical ROUNDUP ROUNDUP ROUNDUP
    Spreadsheet ROW ROW ROW ROW
    Spreadsheet ROWS ROWS ROWS ROWS
    Financial RRI
    Statistic RSQ
    Text SEARCH SEARCH SEARCH
    Mathematical SEC
    Mathematical SECH
    Date&Time SECOND SECOND SECOND SECOND
    Mathematical SERIESSUM No No SERIESSUM
    Spreadsheet SHEET
    Spreadsheet SHEETS
    Mathematical SIGN SIGN SIGN
    Mathematical SIN SIN SIN
    Mathematical SINH SINH SINH
    Statistic SKEW
    Statistic SKEWP
    Financial SLN SLN SLN SLN
    Statistic SLOPE SLOPE SLOPE
    Statistic SMALL SMALL SMALL
    Mathematical SQRT SQRT SQRT
    Mathematical SQRTPI No SQRTPI
    Statistic STANDARDIZE STANDARDIZE
    Statistic STDEV STDEV STDEV
    Statistic STDEV.P
    Statistic STDEV.S
    Statistic STDEVA STDEVA STDEVA
    Statistic STDEVP STDEVP STDEVP
    Statistic STDEVPA STDEVPA STDEVPA
    Statistic STEYX
    Duration No No STRIPDURATION[20]
    Spreadsheet STYLE
    Text SUBSTITUTE SUBSTITUTE SUBSTITUTE SUBSTITUTE
    Mathematical SUBTOTAL
    Mathematical SUM SUM SUM
    Mathematical SUMIF SUMIF SUMIF
    Mathematical SUMIFS No SUMIFS
    Array SUMPRODUCT SUMPRODUCT SUMPRODUCT
    Mathematical SUMSQ SUMSQ SUMSQ
    Array SUMX2MY2 No SUMX2MY2
    Array SUMX2PY2 No SUMX2PY2
    Array SUMXMY2 No SUMXMY2
    Financial SYD SYD SYD SYD
    Text T T T T
    Statistic T.DIST
    Statistic T.DIST.2T
    Statistic T.DIST.RT
    Statistic T.INV
    Statistic T.INV.2T
    Statistic T.TEST
    Mathematical TAN TAN TAN
    Mathematical TANH TANH TANH
    Financial TBILLEQ
    Financial TBILLPRICE
    Financial TBILLYIELD
    Statistic TDIST TDIST
    Text TEXT
    Date&Time TIME TIME TIME TIME
    Date&Time TIMEVALUE TIMEVALUE TIMEVALUE TIMEVALUE
    Statistic TINV TINV
    Date&Time TODAY TODAY TODAY TODAY
    Array TRANSPOSE No TRANSPOSE TRANSPOSE
    Array TREND
    Text TRIM TRIM TRIM
    Statistic TRIMMEAN
    Logical TRUE TRUE TRUE TRUE
    Mathematical TRUNC TRUNC TRUNC
    Statistic TTEST No TTEST TTEST
    Information TYPE
    Text UNICHAR CHAR CHAR CHAR
    Text UNICODE CODE CODE CODE
    Array Not needed Not needed Not needed UNION.RANGES[21]
    Text UPPER UPPER UPPER
    Text VALUE VALUE VALUE
    Statistic VAR VAR VAR
    Statistic VAR.P
    Statistic VAR.S
    Statistic VARA VARA VARA
    Statistic VARP VARP VARP
    Statistic VARPA VARPA VARPA
    Financial VDB VDB VDB VDB
    Spreadsheet VLOOKUP VLOOKUP VLOOKUP VLOOKUP
    Text WEBSERVICE
    Date&Time WEEKDAY WEEKDAY WEEKDAY WEEKDAY
    Date&Time WEEKNUM No WEEKNUM WEEKNUM
    Date&Time WEEKNUM_ADD
    Date&Time WEEKS
    Date&Time WEEKSINYEAR
    Statistic WEIBULL No No WEIBULL
    Statistic WEIBULL.DIST
    Date&Time WORKDAY No WORKDAY WORKDAY
    Date&Time WORKDAY.INTL
    Financial XIRR
    Financial XNPV
    Logical XOR
    Date&Time YEAR YEAR YEAR YEAR
    Date&Time YEARFRAC No YEARFRAC YEARFRAC
    Date&Time YEARS
    Financial YIELD No YIELD YIELD
    Financial YIELDDISC No YIELDDISC YIELDDISC
    Financial YIELDMAT No YIELDMAT YIELDMAT
    Statistic Z.TEST
    Statistic ZTEST ZTEST
    Sum of functions 483 168 262

    Notes & References

    1. ↑ 1.0 1.1 Numbers doesn't support the R1C1 annotation.
    2. ↑ 2.0 2.1 NUMTOBASE and BASETONUM calculates numbers. DEC2BIN, DEC2OCT, DEC2HEX do the same to Basis 2, 8, and 16.
    3. ↑ 3.00 3.01 3.02 3.03 3.04 3.05 3.06 3.07 3.08 3.09 3.10 3.11 Apple's functions BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX all supports a second optional parameter which adds padding 0 infront of the result.
    4. ↑ 4.0 4.1 4.2 Calc and Numbers both remove characters 0-31 as specified in the OOXML specification. Calc also removes character 127. Other seldom used non-printable characters (129, 141, 143, 144, 157, or some Unicode defined ones) are not removed by both spreadsheet applications as defined in ODF. This is tracked in bug report tdf#97706.
    5. ↑ 5.0 5.1 5.2 Numbers has additional support for converting to "week", which is neither defined in OOXML nor in ODF.
    6. ↑ 6.0 6.1 Apple's documentation has an example which is wrong, but works correctly. (wrong result, wrong count of parameters)
    7. ↑ 7.0 7.1 7.2 Apple Numbers' DATEVALUE results a date/time value, LibreOffice' DATEVALUE results in an internal Number as specified in OOXML and ODF. Apple states in the manual that this function was integrated for compatibility reasons with "other spreadsheet applications".
    8. ↑ 8.0 8.1 Apple Numbers' DURATION refers to a length of time; LibreOffice Calc's DURATION is a function to measure a bond price's response.
    9. ↑ 9.0 9.1 9.2 9.3 9.4 9.5 9.6 Apple Numbers' functions EDATE and EOMONTH give a date/time value back, LibreOffice results in an internal number as specified in OOXML and ODF.
    10. ↑ 10.0 10.1 Numbers doesn't support the R1C1 annotation.
    11. ↑ Apple's INTERSECT.RANGES was "primarily for compatibility with other spreadsheet apps [sic]." The documentation states further that other spreadsheet applications including Numbers ’08 and Numbers ’09 a "simple space is used as the intersect operator". In LibreOffice Calc a ! is used as intersect operator.
    12. ↑ 12.0 12.1 LibreOffice 5.3 will also accept arrays for MIRR as input (which Numbers already does), see bug reports tdf#58585 (for MIRR and IRR) and tdf#100767 (for MIRR).
    13. ↑ 13.0 13.1 13.2 Apple Numbers (and Microsoft's Excel) return the first number, if more than one number occurs the maximum multiple times in the arguments as defined in the OOXML specification. Calc returns the smallest number like defined in the ODF specification. That is tracked in tdf#97977.
    14. ↑ TODO: Test behaviour in old Numbers.
    15. ↑ TODO: Test behaviour in old Numbers.
    16. ↑ Documentation online
    17. ↑ POLYNOMIAL is only a simplyfication of SERIESSUM with the second parameter always 0 and parameter 3 always 1.
    18. ↑ 18.0 18.1 18.2 18.3 Numbers does not uppercase characters after an apostrophe (‘). LibreOffice Calc does. TODO: What does OOXML / ODF spec says?
    19. ↑ TODO: LibreOffice Calc allows a maximum of 255 characters. What hapens in Numbers?
    20. ↑ STRIPDURATION is included for compatibility reasons with "other spreadsheet software". If AppleWorks, Excel, or Number '08 files are imported to Numbers '09, Apple includes this command where it is needed and removes it when exporting to Excel.
    21. ↑ Apple's UNION.RANGES documentation states that it replaces "the use of a space as the intersect operator in table-spanning references in some other spreadsheet apps, including Numbers ’08 for Mac and Numbers ’09 for Mac."

    See also

    Retrieved from "https://wiki.documentfoundation.org/index.php?title=Functions_comparison_of_LibreOffice_Calc_and_Numbers&oldid=261234"