Skip to main content
Back to homepage →

What is in Excel but not in Calc XLS? - Knowledgebase / Calc XLS - Mariner Software

What is in Excel but not in Calc XLS?

Authors list

What features and functions are in Excel but not in Calc XLS?

There are literally thousands of features in Excel and there are many we don't support. Below is a list of the functions we don't support (yet).

As of version 4.0

 

FEATURES:

graphics

charts

ODBC lookups

cell protection

sheet protection

workbook protection

password protection

pivot tables

OLE linked/embedded files

Nested named ranges

external references

conditional formatting

macros

Visual Basic

 

here is a function list that we don't support:

GETPIVOTDATA

HYPERLINK

RTD

TRANSPOSE

 

EDATE

EOMONTH

NETWORKDAYS

WEEKNUM

WORKDAY

YEARFRAC

 

BESSELI

BESSELJ

BESSELK

BESSELY

COMPLEX

ERF

ERFC

FACTDOUBLE

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

IMPOWER

IMPRODUCT

IMREAL

IMSIN

IMSQRT

IMSUB

IMSUM

 

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

CUMIPMT

CUMPRINC

DISC

DOLLARDE

DOLLARFR

DURATION

EFFECT

FVSCHEDULE

INTRATE

MDURATION

NOMINAL

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

PRICE

PRICEDISC

PRICEMAT

RECEIVED

TBILLEQ

TBILLPRICE

TBILLYIELD

XIRR

XNPV

YIELD

YIELDDISC

YIELDMAT

 

INFO

 

IFERROR

 

FACTDOUBLE

GCD

LCM

MDETERM

MINVERSE

MMULT

MROUND

MULTINOMIAL

QUOTIENT

 

RANDBETWEEN

SERIESSUM

SQRTPI

SUBTOTAL

 

SUMIFS

SUMPRODUCT

 

ASC

BAHTTEXT

 

AVERAGEA

AVERAGEIF

AVERAGEIFS

 

COUNTIFS

EXPONDIST

 

FREQUENCY

GROWTH

LINEST

LOGEST

MAXA

MINA

PERCENTRANK

RSQ

STDEVA

STDEVP

STDEVPA

TREND

VARA

VARP

VARPA

 

Helpful Unhelpful

14 of 20 people found this page helpful