Functions comparison of LibreOffice Calc and PlanMaker

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

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• Events
• Work Items
• Slogan
• Ideas
• US Marketing
• Branding
• Marketing Logo/Artwork Resources

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
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
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	CHOICE
Spredsheet	CHOOSE	CHOOSE
Text	CLEAN	CLEAN
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
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
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
Date&Time	DAYS360	DAYS360
Date&Time	DAYS	DAYSP
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	Partial
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	HOLIDAY
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