General information
IronCalc is in it's infancy, although we aim at supporting many of common spreadsheet features you might find some important features missing in your normal workflow.
If the lack of a particular feature is stopping you from using IronCalc please let us know and we will try to prioritize that over others.
With those caveats IronCalc is perfectly usable and if your workflow doesn't require non supported features, you can use it right away!
IronCalc intends to be Excel compatible, if a formula is evaluated differently in Excel than in IronCalc it is most likely a bug
List of supported functions
We support a wealth of functions already, you can track the development in IronCalc Functions.
At the moment IronCalc does not support any function in this section. All are planned.
DAVERAGE |
DCOUNT |
DCOUNTA |
DGET |
DMAX |
DMIN |
DPRODUCT |
DSTDEV |
DSTDEVP |
DSUM |
DVAR |
DVARP |
DATE |
DATEDIF |
DATEVALUE |
DAY |
DAYS |
DAYS360 |
EDATE |
EOMONTH |
HOUR |
ISOWEEKNUM |
MINUTE |
MONTH |
NETWORKDAYS |
NETWORKDAYS.INTL |
NOW |
SECOND |
TIME |
TIMEVALUE |
TODAY |
WEEKDAY |
WEEKNUM |
WORKDAY |
WORKDAY.INTL |
YEAR |
YEARFRAC |
BESSELI |
BESSELJ |
BESSELK |
BESSELY |
BIN2DEC |
BIN2HEX |
BIN2OCT |
BITAND |
BITLSHIFT |
BITOR |
BITRSHIFT |
BITXOR |
COMPLEX |
CONVERT |
DEC2BIN |
DEC2HEX |
DEC2OCT |
ERF |
ERF.PRECISE |
ERFC |
ERFC.PRECISE |
GESTEP |
HEX2BIN |
HEX2DEC |
HEX2OCT |
IMABS |
IMAGINARY |
IMARGUMENT |
IMCONJUGATE |
IMCOS |
IMCOSH |
IMCOT |
IMCSC |
IMCSCH |
IMDIV |
IMEXP |
IMLN |
IMLOG10 |
IMLOG2 |
IMPOWER |
IMPRODUCT |
IMREAL |
IMSEC |
IMSECH |
IMSIN |
IMSINH |
IMSQRT |
IMSUB |
IMSUM |
IMTAN |
OCT2BIN |
OCT2DEC |
OCT2HEX |
ACCRINT |
ACCRINTM |
AMORDEGRC |
AMORLINC |
COUPDAYBS |
COUPDAYS |
COUPDAYSNC |
COUPNCD |
COUPNUM |
COUPPCD |
CUMIPMT |
CUMPRINC |
DB |
DDB |
DISC |
DOLLARDE |
DOLLARFR |
DURATION |
EFFECT |
FV |
FVSCHEDULE |
INTRATE |
IPMT |
IRR |
ISPMT |
MDURATION |
MIRR |
NOMINAL |
NPER |
NPV |
ODDFPRICE |
ODDFYIELD |
ODDLPRICE |
ODDLYIELD |
PDURATION |
PMT |
PPMT |
PRICE |
PRICEDISC |
PRICEMAT |
PV |
RATE |
RECEIVED |
RRI |
SLN |
SYD |
TBILLEQ |
TBILLPRICE |
TBILLYIELD |
VDB |
XIRR |
XNPV |
YIELD |
YIELDDISC |
YIELDMAT |
CELL |
ERROR.TYPE |
INFO |
ISBLANK |
ISERR |
ISERROR |
ISEVEN |
ISFORMULA |
ISLOGICAL |
ISNA |
ISNONTEXT |
ISNUMBER |
ISODD |
ISOMITTED |
ISREF |
ISTEXT |
N |
NA |
SHEET |
SHEETS |
TYPE |
AND |
BYCOL |
BYROW |
FALSE |
IF |
IFERROR |
IFNA |
IFS |
LAMBDA |
LET |
MAKEARRAY |
MAP |
NOT |
OR |
REDUCE |
SCAN |
SWITCH |
TRUE |
XOR |
ADDRESS |
AREAS |
CHOOSE |
CHOOSECOLS |
CHOOSEROWS |
COLUMN |
COLUMNS |
DROP |
EXPAND |
FILTER |
FORMULATEXT |
GETPIVOTDATA |
HLOOKUP |
HSTACK |
HYPERLINK |
IMAGE |
INDEX |
INDIRECT |
LOOKUP |
MATCH |
OFFSET |
ROW |
ROWS |
RTD |
SORT |
SORTBY |
TAKE |
TOCOL |
TOROW |
TRANSPOSE |
UNIQUE |
VLOOKUP |
VSTACK |
WRAPCOLS |
WRAPROWS |
XLOOKUP |
XMATCH |
ABS |
ACOS |
ACOSH |
ACOT |
ACOTH |
AGGREGATE |
ARABIC |
ASIN |
ASINH |
ATAN |
ATAN2 |
ATANH |
BASE |
CEILING |
CEILING.MATH |
CEILING.PRECISE |
COMBIN |
COMBINA |
COS |
COSH |
COT |
COTH |
CSC |
CSCH |
DECIMAL |
DEGREES |
EVEN |
EXP |
FACT |
FACTDOUBLE |
FLOOR |
FLOOR.MATH |
FLOOR.PRECISE |
GCD |
INT |
ISO.CEILING |
LCM |
LET |
LN |
LOG |
LOG10 |
MDETERM |
MINVERSE |
MMULT |
MOD |
MROUND |
MULTINOMIAL |
MUNIT |
ODD |
PI |
POWER |
PRODUCT |
QUOTIENT |
RADIANS |
RAND |
RANDARRAY |
RANDBETWEEN |
ROMAN |
ROUND |
ROUNDDOWN |
ROUNDUP |
SEC |
SECH |
SERIESSUM |
SEQUENCE |
SIGN |
SIN |
SINH |
SQRT |
SQRTPI |
SUBTOTAL |
SUM |
SUMIF |
SUMIFS |
SUMPRODUCT |
SUMSQ |
SUMX2MY2 |
SUMX2PY2 |
SUMXMY2 |
TAN |
TANH |
TRUNC |
AVEDEV |
AVERAGE |
AVERAGEA |
AVERAGEIF |
AVERAGEIFS |
BETA.DIST |
BETA.INV |
BINOM.DIST |
BINOM.DIST.RANGE |
BINOM.INV |
CHISQ.DIST |
CHISQ.DIST.RT |
CHISQ.INV |
CHISQ.INV.RT |
CHISQ.TEST |
CONFIDENCE.NORM |
CONFIDENCE.T |
CORREL |
COUNT |
COUNTA |
COUNTBLANK |
COUNTIF |
COUNTIFS |
COVARIANCE.P |
COVARIANCE.S |
DEVSQ |
EXPON.DIST |
F.DIST |
F.DIST.RT |
F.INV |
F.INV.RT |
F.TEST |
FISHER |
FISHERINV |
FORECAST |
FORECAST.ETS |
FORECAST.ETS.CONFINT |
FORECAST.ETS.SEASONALITY |
FORECAST.ETS.STAT |
FORECAST.LINEAR |
FREQUENCY |
GAMMA |
GAMMA.DIST |
GAMMA.INV |
GAMMALN |
GAMMALN.PRECISE |
GAUSS |
GEOMEAN |
GROWTH |
HARMEAN |
HYPGEOM.DIST |
INTERCEPT |
KURT |
LARGE |
LINEST |
LOGEST |
LOGNORM.DIST |
LOGNORM.INV |
MAX |
MAXA |
MAXIFS |
MEDIAN |
MODE.MULT |
MODE.SNGL |
NEGBINOM.DIST |
NORM.DIST |
NORM.INV |
NORM.S.DIST |
NORM.S.INV |
PEARSON |
PERCENTILE.EXC |
PERCENTILE.INC |
PERCENTRANK.EXC |
PERCENTRANK.INC |
PERMUT |
PERMUTATIONA |
PHI |
POISSON.DIST |
PROB |
QUARTILE.EXC |
QUARTILE.INC |
RANK.AVG |
RANK.EQ |
RSQ |
SKEW |
SKEW.P |
SLOPE |
SMALL |
STANDARDIZE |
STDEV.P |
STDEV.S |
STDEVA |
STDEVPA |
STEYX |
T.DIST |
T.DIST.2T |
T.DIST.RT |
T.INV |
T.INV.2T |
T.TEST |
TREND |
TRIMMEAN |
VAR.P |
VAR.S |
VARA |
VARPA |
WEIBULL.DIST |
Z.TEST |
ASC |
ARRAYTOTEXT |
BAHTTEXT |
CHAR |
CLEAN |
CODE |
CONCAT |
CONCATENATE |
DBCS |
DOLLAR |
EXACT |
FIND |
FINDB |
FIXED |
LEFT |
LEFTB |
LEN |
LENB |
LOWER |
MID |
MIDB |
NUMBERVALUE |
PHONETIC |
PROPER |
REPLACE |
REPLACEB |
REPT |
RIGHT |
RIGHTB |
SEARCH |
SEARCHB |
SUBSTITUTE |
T |
TEXT |
TEXTAFTER |
TEXTBEFORE |
TEXTJOIN |
TEXTSPLIT |
TRIM |
UNICHAR |
UNICODE |
UPPER |
VALUE |
VALUETOTEXT |
Formatting Values
You can format numbers in scientific notation, as currencies, percentages or dates.
Using Styles
You can choose background colors, text colors, borders, font styles (bold, italics, underlined). You can also align text horizontally and vertically.
Widths of rows and heights of columns can also be changed
Keyboard shortcuts
From within your keyboard you can navigate and interact with the spreadsheet. This is a fairly interesting feature for power users.
Important unsupported Features
Although IronCalc is ready for you to use it is important for you to understand its limitations. Here we want to list what we feel are the most important missing features of a modern spreadsheet engine. If you can live without those features for now, IronCalc might be the product you are looking for.
Arrays and array formulas
We don't implement arrays or array formulas. Those are planned and coming very soon. This is the highest priority on the engine side.
Name manager
Although IronCalc supports importing and exporting defined names we cannot create/delete/update them in the UI right now. This is expected to be implemented shortly.
Only English supported
The MVP only supports the English language, but we plan to support three languages (English, German and Spanish) for version 1.0
No autocomplete
Spreadsheet users know that given a few cell entries like 1, 2, 3 the engine will autocomplete with 4, 5, 6 in the next cells when extending. This is not yet ready on IronCalc but it is on the roadmap.
Charts
Any serious spreadsheet program should support charts and this will be one of the highest priorities right after version 1.0