Aspose.Cells supports all the standard built-in functions or formulas. The supported list is given below in alphabetical order, the list might not be the final / updated as more and more formulas / functions are added with every new release of the product. Morover, Aspose.Cells also supports a veriety of Addin formulas / functions.
The following list shows the supported formulas / functions which Workbook.CalculateFormula() method can calculate the results at runtime. Aspose.Cells Formula Calculation Engine allows you to set read and calculate the results of the following formulas / functions.
A
[.NET]
ABS, ACOS, ACOSH, ADDRESS, AND, ASIN, ASINH, ATAN, ATAN2, ATANH, AVERAGE
[ JAVA ]
ABS, ACOS, ACOSH, ADDRESS, AND, ASIN, ASINH,
ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA
B
[ JAVA ]
BINOMDIST
C
[.NET]
CEILING, CELL, CHOOSE, CHAR, COLUMN, COLUMNS, CORREL, CONCATENATE, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF
[ JAVA ]
CHAR, CEILING, CHITEST, CHIDIST, CHOOSE, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, COVAR, CRITBINOM, CUMIPMT, CUMPRINC
D
[.NET]
DATE, DATEDIF, DATEVALUE, DAY, DAYS360, DOLLAR
[ JAVA ]
DATE, DATEDIF, DATEVALUE, DAVERAGE, DAY, DAYS360, DB, DCOUNT, DCOUNTA, DDB, DEGREES, DEVSQ, DGET, DMAX, DMIN, DOLLAR, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
E
[.NET]
EOMONTH, EXACT, EXP
[ JAVA ]
ERROR.TYPE, EVEN, EXACT, EXP, EXPONDIST
F
[.NET]
FIND, FIXED, FLOOR, FV
[ JAVA ]
FACT, FALSE, FIND, FISHER, FISHERINV, FIXED, FLOOR, FV
G
[ JAVA ]
GAMMADIST, GAMMALN, GEOMEAN, GROWTH
H
[.NET]
HLOOKUP
[ JAVA ]
HARMEAN, HLOOKUP, HOUR, HYPGEOMDIST
I
[.NET]
IF, INDEX, INDIRECT, INT, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISNA, ISNUMBER, ISREF
[ JAVA ]
IF, INT, INTERCEPT, INDEX, INDIRECT, IPMT, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL
ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT
L
[.NET]
LEFT, LEN, LINEST, LN, LOG10, LOOKUP
[ JAVA ]
LARGE, LEFT, LEN, LINEST, LN, LOG, LOG10, LOGEST, LOOKUP, LOWER
M
[.NET]
MATCH, MAX, MEDIAN, MID, MIN, MOD, MONTH, MROUND
[ JAVA ]
MATCH, MAX, MAXA, MEDIAN, MID, MIN, MINA, MINUTE, MOD, MONTH
N
[.NET]
NA, NORMDIST, NORMINV, NOT, NOW, NPV
[ JAVA ]
N, NA, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPV
O
[.NET]
OFFSET, OR
[ JAVA ]
ODD, OFFSET, OR
P
[.NET]
PEARSON, PERCENTILE, PI, POWER, PPMT, PRODUCT, PV
[ JAVA ]
PEARSON, PERMUT, PI, PMT, POISSON, POWER, PPMT, PRODUCT, PROPER, PV
Q
[.NET ]
QUARTILE
R
[.NET]
RAND, RANK, RATE, REPT, RIGHT, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ
[ JAVA ]
RADIANS, RAND, RANDBETWEEN, RANK, RATE, REPLACE, REPT, RIGHT, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ
S
[.NET]
SIGN, SIN, SINH, SMALL, SQRT, STDEV, SUBSTITUTE, SUM, SUMIF, SUMPRODUCT
[ JAVA ]
SEARCH, SECOND, SIGN, SIN, SINH, SKEW, SLN, SLOPE, SMALL, SQRT, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, SUBSTITUTE, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD
T
[.NET]
TAN, TANH, TEXT, TIME, TODAY, TRUNC
[ JAVA ]
T, TAN, TANH, TEXT, TIME, TIMEVALUE, TODAY, TREND, TRIM, TRIMMEAN, TRUE, TRUNC, TYPE
U
[.NET]
UPPER
[ JAVA ]
UPPER, USDOLLAR
V
[.NET]
VALUE, VLOOKUP
[ JAVA ]
VALUE, VAR, VARA, VARP, VARPA, VDB, VLOOKUP
W
[ JAVA ]
WEEKDAY, WEEKNUM, WEIBULL
X
[.NET]
XIRR
Y
[.NET]
YEAR, YEARFRAC
[ JAVA ]
YEAR
Some Supported Add-in Functions:
[.NET]
MCORRELS, REGRESSN
The following list shows the supported formulas / functions which Aspose.Cells Formula Calculation Engine allows you to set and read the formulas / functions.
[A]
[.NET]
ABS, ACOS, ACOSH, ADDRESS, AND, ASC, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA
[JAVA]
ABS, ACOS, ACOSH, ADDRESS, AND, AREAS, ASC, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA
[B]
[JAVA]
BETADIST, BETAINV, BINOMDIST
[C]
[.NET]
CEILING, CELL, CHAR, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CORREL, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF
[JAVA]
CEILING, CELL, CHAR, CHIDIST, CHITEST, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, COVAR, CRITBINOM, CUMIPMT, CUMPRINC
[D]
[.NET]
DATE, DATEDIF, DATEVALUE, DAVERAGE, DAY, DAYS360, DCOUNT, DCOUNTA, DDB, DEGREES, DGET, DMAX, DMIN, DOLLAR, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
[JAVA]
DATE, DATEDIF, DATESTRING, DATEVALUE, DAVERAGE, DAY, DAYS360, DB, DCOUNT, DCOUNTA, DDB, DEVSQ, DEGREES, DGET, DMAX, DMIN, DOLLAR, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
[E]
[.NET]
EVEN, EXACT, EXP
[JAVA]
ERROR.TYPE, EVEN, EXACT, EXP, EXPONDIST
[F]
[.NET]
FACT, FALSE, FIND, FIXED, FLOOR, FORECAST, FTEST, FV
[JAVA]
FACT, FALSE, FIND, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FTEST, FV
[G]
[.NET]
GETPIVOTDATA
[JAVA]
GAMMADIST, GAMMAINV, GAMMALN, GEOMEAN, GETPIVOTDATA, GROWTH
[H]
[.NET]
HLOOKUP, HOUR, HYPERLINK
[JAVA]
HARMEAN, HLOOKUP, HOUR, HYPERLINK, HYPGEOMDIST
[I]
[.NET]
IF, INDEX, INDIRECT, IPMT, INT, IRR, ISBLANK, ISERR, ISERROR, ISNA, ISNUMBER, ISREF
[JAVA]
IF, INDIRECT, INFO, INT, INTERCEPT, INDEX, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISPMT, ISREF, ISTEXT
[K]
[JAVA]
KURT
[L]
[.NET]
LEFT, LEN, LINEST, LN, LOG, LOG10, LOOKUP, LOWER
[JAVA]
LARGE, LEFT, LEN, LINEST, LN, LOOKUP, LOG, LOG10, LOGEST, LOWER
[M]
[.NET]
MATCH, MAX, MEDIAN, MID, MIN, MINUTE, MIRR, MMULT, MOD, MONTH
[JAVA]
MATCH, MAX, MAXA, MDETERM, MEDIAN, MID, MIN, MINA, MINUTE, MINVERSE, MIRR, MMULT, MOD, MONTH
[N]
[.NET]
N, NA, NORMDIST, NORMINV, NORMSDIST, NOT, NOW, NPER, NPV
[JAVA]
N, NA, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV, NUMBERSTRING
[O]
[.NET]
ODD, OFFSET,OR
[JAVA]
ODD, OFFSET, OR
[P]
[.NET]
PEARSON, PERCENTILE, PI, PMT, POWER, PPMT, PRODUCT, PV
[JAVA]
PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PHONETIC, PI, PMT, POISSON, POWER, PPMT, PROB, PRODUCT, PROPER, PV
[Q]
[.NET]
QUARTILE
[JAVA]
QUARTILE
[R]
[.NET]
RADIANS, RAND, RANK, RATE, REPLACE, REPT, RIGHT, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ
[JAVA]
RADIANS, RAND, RANK, RATE, REPLACE, REPT, RIGHT, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ
[S]
[.NET]
SEARCH, SECOND, SIGN, SIN, SINH, SLN, SQRT, STDEV, STDEVP, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD
[JAVA]
SEARCH, SECOND, SIGN, SIN, SINH, SKEW, SLN, SLOPE, SMALL, SQRT, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, STEYX, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD
[T]
[.NET]
T, TAN, TANH, TDIST, TEXT, TIME, TODAY, TRANSPOSE, TRIM, TRUE, TRUNC
[JAVA]
T, TAN, TANH, TDIST, TEXT, TIME, TIMEVALUE, TINV, TODAY, TRANSPOSE, TREND, TRIM, TRIMMEAN, TRUE, TRUNC, TTEST, TYPE
[U]
[.NET]
UPPER
[JAVA]
UPPER, USDOLLAR
[V]
[.NET]
VALUE, VLOOKUP
[JAVA]
VALUE, VAR, VARA, VARP, VARPA, VDB, VLOOKUP
[W]
[.NET]
WEEKDAY, WIDECHAR
[JAVA]
WEEKDAY, WEEKNUM, WEIBULL, WIDECHAR
[Y]
[.NET]
YEAR
[JAVA]
YEAR
[Z]
[JAVA]
ZTEST