Functions comparison of LibreOffice Calc and PlanMaker

From The Document Foundation Wiki
Jump to: navigation, search

PlanMaker is the spreadsheet application of SoftMaker Office. The page compares the available functions between SofMaker's PlanMaker and LibreOffice Calc.

The functions of Numbers were taken of the official documentations which can be accessed at SoftMaker.com. All functions which are not available in LibreOffice Calc are tracked in tdf#123. (ticket has to be created after most functions are analysed)


Work In Progress by Dennis Roczek (talk) 2018-10-02T17:11:52 (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 latest LibreOffice which had been added in the meantime (e.g. Forecasts functions).
  • Yes, I do know that the count of functions need to be updated; this works only at the end when every function was analyzed (see e.g. BINOMDIST and B).
  • test all functions


Summary of comparison

Legend in this table:

  • green means: Every function in this spreadsheet software is available
  • yellow means: Some functions are available, but there exists other functions which are available in other spreadsheet software (e.g. EASTERSUNDAY/HOLIDAY in group Date&Time)
  • red means: No function at all are available in this spreadsheet software
  • todo means: need to be checked; function-name(!) itself is not available in LibreOffice and thus needs either a mapping to another function or moved to an existing function group (or a new function group should be added to this comparison)
Function Group LibreOffice 5.0 Calc (!) SoftMaker PlanMaker 2018
Function Group LibreOffice 5.0 Calc PlanMaker 2018
Add-in 50 41
Array 10 9
Database 12 12
Date&Time 26 23
Duration 0 0
Financial 59 25
Infirmation 21 18
Logical 7 6
Mathematical 81 61
Spredsheet 21 16
Statistic 137 80
Text 41 24
todo 0 23
Sum 465 338
unique functions tbd XYZ: CHOISE, COUNTP, CREATEDATE, HOLIDAY, ISNUMBERP

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 (!) SoftMaker PlanMaker 2018
Financial ACCRINT
Financial ACCRINTM
Mathematical ACOS ACOS
Mathematical ACOSH ACOSH
Mathematical ACOT ACOT
Mathematical ACOTH ACOTH
Spredsheet ADDRESS ADDRESS
Mathematical AGGREGATE
Financial AMORDEGRC
Financial AMORLINC
Logical AND AND
Text ARABIC
Spredsheet AREAS AREAS
Text ASC
Text ASIN ASIN
Mathematical ASINH ASINH
Mathematical ATAN ATAN
Mathematical ATAN2 ATAN2
Mathematical ATANH ATANH
Statistic AVEDEV AVEDEV
Statistic AVERAGE AVERAGE
Statistic AVERAGEA AVERAGEA
Statistic AVERAGEIF AVERAGEIF
Statistic AVERAGEIFS AVERAGEIFS
Statistic B No[1]
Text BAHTTEXT
Text BASE BASE
Add-in BESSELI BESSELI
Add-in BESSELJ BESSELJ
Add-in BESSELK BESSELK
Add-in BESSELY BESSELY
Statistic BETA.DIST
Statistic BETA.INV
Statistic BETADIST BETADIST
Statistic BETAINV BETAINV
Add-in BIN2DEC BIN2DEC
Add-in BIN2HEX BIN2HEX
Add-in BIN2OCT BIN2OCT
Statistic BINOM.DIST
Statistic BINOM.INV
Statistic BINOMDIST BINOMDIST[1]
Mathematical BITAND
Mathematical BITLSHIFT
Mathematical BITOR
Mathematical BITRSHIFT
Mathematical BITXOR
Mathematical CEILING CEILING
Mathematical CEILING.MATH
Mathematical CEILING.PRECISE
Mathematical CEILING.XCL
Infirmation CELL CELL
Text CHAR 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
Statistic Partial[2] CHOICE [2]
Spredsheet CHOOSE CHOOSE
Text CLEAN[3] CLEAN[3]
Text CODE CODE
Mathematical COLOR
Spredsheet COLUMN COLUMN
Spredsheet COLUMNS COLUMNS
Mathematical COMBIN COMBIN
Mathematical COMBINA
Add-in COMPLEX COMPLEX
Text CONCATENATE CONCATENATE
Statistic CONFIDENCE CONFIDENCE
Statistic CONFIDENCE.NORM
Statistic CONFIDENCE.T
Add-in CONVERT CONVERT
Add-in CONVERT_ADD
Statistic CORREL CORREL
Statistic COS COS
Mathematical COSH COSH
Mathematical COT COT
Mathematical COTH COTH
Statistic COUNT COUNT
Statistic COUNTA COUNTA
Statistic COUNTBLANK COUNTBLANK
Statistic COUNTIF COUNTIF
Statistic COUNTIFS COUNTIFS
Statistic No COUNTP[4]
Financial COUPDAYBS
Financial COUPDAYS
Financial COUPDAYSNC
Financial COUPNCD
Financial COUPNUM
Financial COUPPCD
Statistic COVAR COVAR
Statistic COVARIANCE.P
Statistic COVARIANCE.S
Statistic CRITBINOM
Mathematical CSC
Mathematical CSCH
Date&Time No CREATEDATE[5]
todo CRITBINOM
Financial CUMIPMT CUMIPMT
Financial CUMIPMT_ADD
Financial CUMPRINC CUMPRINC
Financial CUMPRINC_ADD
Financial No CURRENCY
Infirmation CURRENT
Date&Time DATE DATE
Date&Time DATEDIF DATEDIF
Date&Time DATEVALUE DATEVALUE
Database DAVERAGE DAVERAGE
Date&Time DAY DAY
Date&Time DAYS DAYS[6]
Date&Time DAYS360 DAYS360
Date&Time DAYS[6] DAYSP[6]
Date&Time DAYSINMONTH DAYSPERMONTH
Date&Time DAYSINYEAR DAYSPERYEAR
Financial DB DB
Database DCOUNT DCOUNT
Database DCOUNTA DCOUNTA
Financial DDB DDB
Spredsheet DDE
Add-in DEC2BIN DEC2BIN
Add-in DEC2HEX DEC2HEX
Add-in DEC2OCT DEC2OCT
todo DECIBEL
Text DECIMAL DECIMAL
todo DECIMALS
Mathematical DEGREES DEGREES
Add-in DELTA DELTA
Statistic DEVSQ DEVSQ
Database DGET DGET
Financial DISC
Database DMAX DMAX
Database DMIN DMIN
Text DOLLAR
Text DOLLARDE DOLLARDE
Financial DOLLARFR DOLLARFR
Database DPRODUCT DPRODUCT
Database DSTDEV DSTDEV
Database DSTDEVP DSTDEVP
Database DSUM DSUM
Financial DURATION
Financial DURATION_ADD
Database DVAR DVAR
Database DVARP DVARP
Date&Time EASTERSUNDAY [7] Partial[7]
Date&Time EDATE EDATE
Financial EFFECT EFFECT
Financial EFFECTIVE
Text ENCODEURL
Date&Time EOMONTH EOMONTH
Add-in ERF ERF
Statistic ERF.PRECISE
Add-in ERFC ERFC
Statistic ERFC.PRECISE
Spredsheet ERROR.TYPE ERROR.TYPE
Spredsheet ERRORTYPE
Mathematical EUROCONVERT EUROCONVERT
Mathematical EVEN EVEN
Text EXACT EXACT
Mathematical 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
Add-in FACTDOUBLE FACTDOUBLE
Logical FALSE FALSE
Statistic FDIST FDIST
todo FILENAME
Text FILTERXML
Text FIND FIND
Statistic FINV FINV
Statistic FISHER FISHER
Statistic FISHERINV FISHERINV
Text FIXED FIXED
Mathematical FLOOR FLOOR
Mathematical FLOOR.MATH
Mathematical FLOOR.PRECISE
Mathematical FLOOR.XCL
Statistic FORECAST FORECAST
Infirmation FORMULA FORMULATEXT
Array FREQUENCY FREQUENCY
Statistic FTEST FTEST
Financial FV FV
Financial FVSCHEDULE FVSCHEDULE
Financial GAMMA GAMMA
Statistic GAMMA.DIST
Statistic GAMMA.INV
Statistic GAMMADIST GAMMADIST
Statistic GAMMAINV GAMMAINV
Statistic GAMMALN GAMMALN
Statistic GAMMALN.PRECISE
Statistic GAUSS GAUSS
Mathematical GCD GCD
Mathematical GCD_ADD
Statistic GEOMEAN GEOMEAN
Add-in GESTEP GESTEP
Spredsheet GETPIVOTDATA
Array GROWTH GROWTH
Statistic HARMEAN HARMEAN
Add-in HEX2BIN HEX2BIN
Add-in HEX2DEC HEX2DEC
Add-in HEX2OCT HEX2OCT
Spredsheet HLOOKUP HLOOKUP
Date&Time Partial[7] HOLIDAY[7]
Date&Time HOUR HOUR
Spredsheet HYPERLINK HYPERLINK
Statistic HYPGEOM.DIST
Statistic HYPGEOMDIST HYPGEOMDIST
Statistic IF IF
Logical IFERROR IFERROR
Logical IFNA
Add-in IMABS IMABS
Add-in IMAGINARY IMAGINARY
Add-in IMARGUMENT IMARGUMENT
Add-in IMCONJUGATE IMCONJUGATE
Add-in IMCOS IMCOS
Add-in IMCOSH
Add-in IMCOT
Add-in IMCSC
Add-in IMCSCH
Add-in IMDIV IMDIV
Add-in IMEXP IMEXP
Add-in IMLN IMLN
Add-in IMLOG10 IMLOG10
Add-in IMLOG2 IMLOG2
todo IMNEG
Add-in IMPOWER IMPOWER
Add-in IMPRODUCT IMPRODUCT
Add-in IMREAL IMREAL
Add-in IMSEC
Add-in IMSECH
Add-in IMSIN IMSIN
Add-in IMSINH
Add-in IMSQRT IMSQRT
Add-in IMSUB IMSUB
Add-in IMSUM IMSUM
Add-in IMTAN
Spredsheet INDEX INDEX
Spredsheet INDIRECT INDIRECT
Infirmation INFO
Mathematical INT INT
Statistic INTERCEPT INTERCEPT
todo INTERSECTION
Financial INTRATE
Financial IPMT IPMT
Financial IRR IRR
Infirmation ISBLANK ISBLANK
Infirmation ISERR ISERR
Infirmation ISERROR ISERROR
Infirmation ISEVEN ISEVEN
Infirmation ISEVEN_ADD
Infirmation ISFORMULA ISFORMULA
Date&Time ISLEAPYEAR
Infirmation ISLOGICAL ISLOGICAL
Infirmation ISNA ISNA
Infirmation ISNONTEXT ISNONTEXT
Infirmation MBER ISNUMBER
Infirmation No ISNUMBERP
Mathematical ISO.CEILING
Infirmation ISODD ISODD
Infirmation ISODD_ADD
todo ISOWEEK
todo ISOWEEKNUM
Financial ISPMT ISPMT
Infirmation ISREF ISREF
Infirmation ISTEXT ISTEXT
Text JIS
Statistic KURT KURT
Statistic LARGE LARGE
todo LASTPRINTED
todo LASTSAVED
Mathematical LCM LCM
Mathematical LCM_ADD
Mathematical LEFT LEFT
Text LEFTB
Text LEN LEN
Text LENB
Array LINEST LINEST
Mathematical LN LN
Mathematical LOG LOG
Mathematical LOG10 LOG10
Array LOGEST LOGEST
Statistic LOGINV LOGINV
Statistic LOGNORM.DIST
Statistic LOGNORM.INV
Statistic LOGNORMDIST LOGNORMDIST
Spredsheet LOOKUP LOOKUP
Text LOWER LOWER
Spredsheet MATCH MATCH
Statistic MAX MAX
Statistic MAXA MAXA
Array MDETERM MDETERM
Financial MDURATION
Statistic MEDIAN MEDIAN
Statistic MID MID
Text MIDB
todo MILLISECONDS
Statistic MIN MIN
Statistic MINA MINA
Date&Time MINUTE MINUTE
Array MINVERSE MINVERSE
Financial MIRR MIRR
Array MMULT MMULT
Mathematical MOD MOD
Mathematical MODE MODE
todo MODP
Statistic MODE.MULT
Statistic MODE.SNGL
Date&Time MONTH MONTH
Date&Time MONTHS
Mathematical MROUND MROUND
todo MSOLVE
Mathematical MULTINOMIAL MULTINOMIAL
Array MUNIT
Infirmation N N
Infirmation NA NA
todo NEG
Statistic NEGBINOM.DIST
Statistic NEGBINOMDIST NEGBINOMDIST
Date&Time 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
Date&Time NOW NOW
Financial NPER NPER
Financial NPV NPV
Text NUMBERVALUE
Add-in OCT2BIN OCT2BIN
Add-in OCT2DEC OCT2DEC
Add-in OCT2HEX OCT2HEX
Add-in ODD ODD
Financial ODDFPRICE
Financial ODDFYIELD
Financial ODDLPRICE
Financial ODDLYIELD
Spredsheet OFFSET OFFSET
Financial OPT_BARRIER
Financial OPT_PROB_HIT
Financial OPT_PROB_INMONEY
Financial OPT_TOUCH
Logical OR OR
todo RRI
Statistic PEARSON PEARSON
Statistic PERCENTILE PERCENTILE
Statistic PERCENTILE.EXC
Statistic PERCENTILE.INC
Statistic PERCENTRANK PERCENTRANK
Statistic PERCENTRANK.EXC
Statistic PERCENTRANK.INC
todo PERIOD
Statistic PERMUT PERMUT
Statistic PERMUTATIONA
Statistic PHI PHI
Mathematical PI PI
Financial PMT PMT
Statistic POISSON POISSON
Statistic POISSON.DIST
Mathematical POWER POWER
Financial PPMT PPMT
Financial PRICE
Financial PRICEDISC
Financial PRICEMAT
Statistic PROB PROB
Mathematical PRODUCT PRODUCT
Text PROPER PROPER
Financial PV PV
Statistic QUARTILE QUARTILE
Statistic QUARTILE.EXC
Statistic QUARTILE.INC
Mathematical QUOTIENT QUOTIENT
Mathematical RADIANS RADIANS
Mathematical RAND RAND
Mathematical RANDBETWEEN RANDBETWEEN
Mathematical RANK RANK
Statistic RANK.AVG
Statistic RANK.EQ
Financial RATE RATE
Financial RECEIVED
Text REPLACE REPLACE
Text REPT REPT
Text RIGHT RIGHT
Text RIGHTB
Text ROMAN ROMAN
Text ROT13
todo ROOTN
Mathematical ROUND ROUND
Mathematical ROUNDDOWN ROUNDDOWN
Mathematical ROUNDUP ROUNDUP
Spredsheet ROW ROW
Spredsheet ROWS ROWS
Financial RRI
Statistic RSQ RSQ
Text SEARCH SEARCH
Text SEC
Mathematical SECH
Date&Time SECOND SECOND
Mathematical SERIESSUM SERIESSUM
Mathematical SHEET SHEET
Spredsheet SHEETS
todo SHEETNAME
todo SHEETNUMBER
Mathematical SIGN SIGN
Mathematical SIN SIN
Mathematical SINH SINH
Statistic SKEW SKEW
Statistic SKEWP
Financial SLN SLN
Statistic SLOPE SLOPE
Statistic SMALL SMALL
todo SORTM
todo SORTV
Mathematical SQRT SQRT
Mathematical SQRTPI SQRTPI
Statistic STANDARDIZE STANDARDIZE
Statistic STDEV STDEV
Statistic STDEV.P
Statistic STDEV.S
Statistic STDEVA STDEVA
Statistic STDEVP STDEVP
Statistic STDEVPA STDEVPA
Statistic STEYX STEYX
Spredsheet STYLE
Text SUBSTITUTE SUBSTITUTE
Mathematical SUBTOTAL SUBTOTAL
Mathematical SUM SUM
Mathematical SUMIF SUMIF
Mathematical SUMIFS SUMIFS
Mathematical SUMPRODUCT SUMPRODUCT
Mathematical SUMSQ SUMSQ
Mathematical SUMX2MY2 SUMX2MY2
Mathematical SUMX2PY2 SUMX2PY2
Mathematical SUMXMY2 SUMXMY2
Financial SYD SYD
Financial 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
Mathematical TANH TANH
Financial TBILLEQ
Financial TBILLPRICE
Financial TBILLYIELD
Statistic TDIST TDIST
Text TEXT TEXT
Date&Time TIME TIME
todo TIMEDIFF
Date&Time TIMEVALUE TIMEVALUE
Statistic TINV TINV
Date&Time TODAY TODAY
Array TRANSPOSE TRANSPOSE
Array TREND TREND
Text TRIM TRIM
Statistic TRIMMEAN TRIMMEAN
Logical TRUE TRUE
Mathematical TRUNC TRUNC
Statistic TTEST TTEST
Infirmation TYPE TYPE
Text UNICHAR
Text UNICODE
Text UPPER UPPER
todo USERFIELD
Text VALUE VALUE
Statistic VAR VAR
Statistic VAR.P
Statistic VAR.S
Statistic VARA VARA
Statistic VARP VARP
Statistic VARPA VARPA
Financial VDB
Spredsheet VLOOKUP VLOOKUP
Text WEBSERVICE
Date&Time WEEKDAY WEEKDAY
Date&Time WEEKNUM WEEKNUM
Date&Time WEEKNUM_ADD
Date&Time WEEKS
Date&Time WEEKSINYEAR
Statistic WEIBULL WEIBULL
Statistic WEIBULL.DIST
Date&Time WORKDAY WORKDAY
Date&Time WORKDAY.INTL
Financial XIRR XIRR
Financial XNPV XNPV
Logical XOR XOR
Logical YEAR YEAR
Date&Time YEARFRAC
Date&Time YEARS
Financial YIELD
Financial YIELDDISC
Financial YIELDMAT
Statistic Z.TEST
Statistic ZTEST ZTEST
Sum of functions 483 344

Notes & References

  1. 1.0 1.1 B and BINOMDIST: PlanMaker 97 has added a BINOMDIST-function as "B". Excel 2013 added this function and SoftMaker readded it under the same name. The compatibility function "B" shouldn't be used as only PlanMaker can handle it.
  2. 2.0 2.1 CHOISE: A workaround is to use the "IF"-function. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
  3. 3.0 3.1 Calc and PlanMaker 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.
  4. COUNTP: "counts only cells that contain numbers or logical values." This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
  5. CREATEDATE: Returns the date/time the current document was created. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.
  6. 6.0 6.1 6.2 DAYSP: this is a compatibility function with Microsoft Excel. It is identical to DAYS, but has swapped parameters. PlanMaker is not able to map this function automatically as DAYS.
  7. 7.0 7.1 7.2 7.3 HOLIDAY and EASTERSUNDAY: EASTERSUNDAY can be replaced in PlanMaker using HOLIDAY(TODAY(),1); 8 other different movable Christian holidays are also available in PlanMaker. This function is not compatible to Excel and thus PlanMaker only exports a fixed value and looses the function on the import.