Functions comparison of LibreOffice Calc and Numbers

From The Document Foundation Wiki
Jump to: navigation, search

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

Numbers supports wild card searches in multiple functions. LibreOffice Calc supports regular expressions and since LibreOffice Calc 5.2 supports also additional wild card searches.

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