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