Formula function coverage

getCalculatedValue() / toArray(calculateFormulas: true) delegate to excelize's formula engine. This table probes every function PhpSpreadsheet's calculation engine registers (extracted from Calculation/FunctionArray.php) against that engine ? regenerate with go run ./tools/formula-coverage > ../FORMULAS.md from extension/.

466 of 529 PhpSpreadsheet functions are available (63 missing).

Semantics of individual functions may still differ in edge cases (see COMPAT.md); cached results in loaded files are always preferred.

Not available via excelize

• `AREAS`
• `ASC`
• `BYCOL`
• `BYROW`
• `CELL`
• `CHOOSECOLS`
• `CHOOSEROWS`
• `CUBEKPIMEMBER`
• `CUBEMEMBER`
• `CUBEMEMBERPROPERTY`
• `CUBERANKEDMEMBER`
• `CUBESET`
• `CUBESETCOUNT`
• `CUBEVALUE`
• `DATESTRING`
• `DROP`
• `EXPAND`
• `FILTER`
• `FILTERXML`
• `GETPIVOTDATA`
• `GROUPBY`
• `HSTACK`
• `INFO`
• `ISOMITTED`
• `ISTHAIDIGIT`
• `JIS`
• `LAMBDA`
• `LET`
• `LINEST`
• `LOGEST`
• `MAKEARRAY`
• `MAP`
• `MEDIANIF`
• `NUMBERSTRING`
• `NUMBERVALUE`
• `OFFSET`
• `PHONETIC`
• `RANDARRAY`
• `REDUCE`
• `ROUNDBAHTDOWN`
• `ROUNDBAHTUP`
• `RTD`
• `SCAN`
• `SEQUENCE`
• `SINGLE`
• `SORT`
• `TAKE`
• `TEXTSPLIT`
• `THAIDAYOFWEEK`
• `THAIDIGIT`
• `THAIMONTHOFYEAR`
• `THAINUMSOUND`
• `THAINUMSTRING`
• `THAISTRINGLENGTH`
• `THAIYEAR`
• `TOCOL`
• `TOROW`
• `USDOLLAR`
• `VSTACK`
• `WEBSERVICE`
• `WRAPCOLS`
• `WRAPROWS`
• `XMATCH`

Available

| | | | | |---|---|---|---| | ABS | ACCRINT | ACCRINTM | ACOS | | ACOSH | ACOT | ACOTH | ADDRESS | | AGGREGATE | AMORDEGRC | AMORLINC | ANCHORARRAY | | AND | ARABIC | ARRAYTOTEXT | ASIN | | ASINH | ATAN | ATAN2 | ATANH | | AVEDEV | AVERAGE | AVERAGEA | AVERAGEIF | | AVERAGEIFS | BAHTTEXT | BASE | BESSELI | | BESSELJ | BESSELK | BESSELY | BETA.DIST | | BETA.INV | BETADIST | BETAINV | BIN2DEC | | BIN2HEX | BIN2OCT | BINOM.DIST | BINOM.DIST.RANGE | | BINOM.INV | BINOMDIST | BITAND | BITLSHIFT | | BITOR | BITRSHIFT | BITXOR | CEILING | | CEILING.MATH | CEILING.ODS | CEILING.PRECISE | CEILING.XCL | | CHAR | CHIDIST | CHIINV | CHISQ.DIST | | CHISQ.DIST.RT | CHISQ.INV | CHISQ.INV.RT | CHISQ.TEST | | CHITEST | CHOOSE | CLEAN | CODE | | COLUMN | COLUMNS | COMBIN | COMBINA | | COMPLEX | CONCAT | CONCATENATE | CONFIDENCE | | CONFIDENCE.NORM | CONFIDENCE.T | CONVERT | CORREL | | COS | COSH | COT | COTH | | COUNT | COUNTA | COUNTBLANK | COUNTIF | | COUNTIFS | COUPDAYBS | COUPDAYS | COUPDAYSNC | | COUPNCD | COUPNUM | COUPPCD | COVAR | | COVARIANCE.P | COVARIANCE.S | CRITBINOM | CSC | | CSCH | CUMIPMT | CUMPRINC | DATE | | DATEDIF | DATEVALUE | DAVERAGE | DAY | | DAYS | DAYS360 | DB | DBCS | | DCOUNT | DCOUNTA | DDB | DEC2BIN | | DEC2HEX | DEC2OCT | DECIMAL | DEGREES | | DELTA | DEVSQ | DGET | DISC | | DMAX | DMIN | DOLLAR | DOLLARDE | | DOLLARFR | DPRODUCT | DSTDEV | DSTDEVP | | DSUM | DURATION | DVAR | DVARP | | ECMA.CEILING | EDATE | EFFECT | ENCODEURL | | EOMONTH | ERF | ERF.PRECISE | ERFC | | ERFC.PRECISE | ERROR.TYPE | EVEN | EXACT | | EXP | EXPON.DIST | EXPONDIST | F.DIST | | F.DIST.RT | F.INV | F.INV.RT | F.TEST | | FACT | FACTDOUBLE | FALSE | FDIST | | FIND | FINDB | FINV | FISHER | | FISHERINV | FIXED | FLOOR | FLOOR.MATH | | FLOOR.ODS | FLOOR.PRECISE | FLOOR.XCL | FORECAST | | FORECAST.ETS | FORECAST.ETS.CONFINT | FORECAST.ETS.SEASONALITY | FORECAST.ETS.STAT | | FORECAST.LINEAR | FORMULATEXT | FREQUENCY | FTEST | | FV | FVSCHEDULE | GAMMA | GAMMA.DIST | | GAMMA.INV | GAMMADIST | GAMMAINV | GAMMALN | | GAMMALN.PRECISE | GAUSS | GCD | GEOMEAN | | GESTEP | GROWTH | HARMEAN | HEX2BIN | | HEX2DEC | HEX2OCT | HLOOKUP | HOUR | | HYPERLINK | HYPGEOM.DIST | HYPGEOMDIST | IF | | IFERROR | IFNA | IFS | 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 | | INDEX | INDIRECT | INT | INTERCEPT | | INTRATE | IPMT | IRR | ISBLANK | | ISERR | ISERROR | ISEVEN | ISFORMULA | | ISLOGICAL | ISNA | ISNONTEXT | ISNUMBER | | ISO.CEILING | ISODD | ISOWEEKNUM | ISPMT | | ISREF | ISTEXT | KURT | LARGE | | LCM | LEFT | LEFTB | LEN | | LENB | LN | LOG | LOG10 | | LOGINV | LOGNORM.DIST | LOGNORM.INV | LOGNORMDIST | | LOOKUP | LOWER | MATCH | MAX | | MAXA | MAXIFS | MDETERM | MDURATION | | MEDIAN | MID | MIDB | MIN | | MINA | MINIFS | MINUTE | MINVERSE | | MIRR | MMULT | MOD | MODE | | MODE.MULT | MODE.SNGL | MONTH | MROUND | | MULTINOMIAL | MUNIT | N | NA | | NEGBINOM.DIST | NEGBINOMDIST | NETWORKDAYS | NETWORKDAYS.INTL | | NOMINAL | NORM.DIST | NORM.INV | NORM.S.DIST | | NORM.S.INV | NORMDIST | NORMINV | NORMSDIST | | NORMSINV | NOT | NOW | NPER | | NPV | OCT2BIN | OCT2DEC | OCT2HEX | | ODD | ODDFPRICE | ODDFYIELD | ODDLPRICE | | ODDLYIELD | OR | PDURATION | PEARSON | | PERCENTILE | PERCENTILE.EXC | PERCENTILE.INC | PERCENTRANK | | PERCENTRANK.EXC | PERCENTRANK.INC | PERMUT | PERMUTATIONA | | PHI | PI | PMT | POISSON | | POISSON.DIST | POWER | PPMT | PRICE | | PRICEDISC | PRICEMAT | PROB | PRODUCT | | PROPER | PV | QUARTILE | QUARTILE.EXC | | QUARTILE.INC | QUOTIENT | RADIANS | RAND | | RANDBETWEEN | RANK | RANK.AVG | RANK.EQ | | RATE | RECEIVED | REPLACE | REPLACEB | | REPT | RIGHT | RIGHTB | ROMAN | | ROUND | ROUNDDOWN | ROUNDUP | ROW | | ROWS | RRI | RSQ | SEARCH | | SEARCHB | SEC | SECH | SECOND | | SERIESSUM | SHEET | SHEETS | SIGN | | SIN | SINH | SKEW | SKEW.P | | SLN | SLOPE | SMALL | SORTBY | | SQRT | SQRTPI | STANDARDIZE | STDEV | | STDEV.P | STDEV.S | STDEVA | STDEVP | | STDEVPA | STEYX | SUBSTITUTE | SUBTOTAL | | SUM | SUMIF | SUMIFS | SUMPRODUCT | | SUMSQ | SUMX2MY2 | SUMX2PY2 | SUMXMY2 | | SWITCH | SYD | T | T.DIST | | T.DIST.2T | T.DIST.RT | T.INV | T.INV.2T | | T.TEST | TAN | TANH | TBILLEQ | | TBILLPRICE | TBILLYIELD | TDIST | TEXT | | TEXTAFTER | TEXTBEFORE | TEXTJOIN | TIME | | TIMEVALUE | TINV | TODAY | TRANSPOSE | | TREND | TRIM | TRIMMEAN | TRUE | | TRUNC | TTEST | TYPE | UNICHAR | | UNICODE | UNIQUE | UPPER | VALUE | | VALUETOTEXT | VAR | VAR.P | VAR.S | | VARA | VARP | VARPA | VDB | | VLOOKUP | WEEKDAY | WEEKNUM | WEIBULL | | WEIBULL.DIST | WORKDAY | WORKDAY.INTL | XIRR | | XLOOKUP | XNPV | XOR | YEAR | | YEARFRAC | YIELD | YIELDDISC | YIELDMAT | | Z.TEST | ZTEST | | |