Functions comparison of LibreOffice Calc and PlanMaker

    From The Document Foundation Wiki

    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.