In Excel/PDF output, after replacing the cell values with Kintone record data based on the template, the entire sheet is recalculated to update the values of the calculation cells.
Regarding this recalculation, the supported functions are listed in the table below.
If an unsupported function is used, an error like the following will occur.
Failed to calculate some formulas. Error evaluating cell A1... The function [function name] is not supported.
| Function |
|---|
| ABS |
| ACOS |
| ACOSH |
| ADDRESS |
| AND |
| AREAS |
| ASIN |
| ASINH |
| ATAN |
| ATAN2 |
| ATANH |
| AVEDEV |
| AVERAGE |
| AVERAGEIFS |
| BIN2DEC |
| CEILING |
| CHAR |
| CHOOSE |
| CLEAN |
| CODE |
| COLUMN |
| COLUMNS |
| COMBIN |
| COMPLEX |
| CONCAT |
| CONCATENATE |
| COS |
| COSH |
| COUNT |
| COUNTA |
| COUNTBLANK |
| COUNTIF |
| COUNTIFS |
| DATE |
| DATEVALUE |
| DAY |
| DAYS360 |
| DEC2BIN |
| DEC2HEX |
| DEGREES |
| DELTA |
| DEVSQ |
| DGET |
| DMAX |
| DMIN |
| DOLLAR |
| DSUM |
| EDATE |
| EOMONTH |
| ERROR.TYPE |
| EVEN |
| EXACT |
| EXP |
| FACT |
| FACTDOUBLE |
| FALSE |
| FIND |
| FIXED |
| FLOOR |
| FREQUENCY |
| FV |
| GEOMEAN |
| HEX2DEC |
| HLOOKUP |
| HOUR |
| HYPERLINK |
| IF |
| IFERROR |
| IFNA |
| IFS |
| IMAGINARY |
| IMREAL |
| INDEX |
| INDIRECT |
| INT |
| INTERCEPT |
| IPMT |
| IRR |
| ISBLANK |
| ISERR |
| ISERROR |
| ISEVEN |
| ISLOGICAL |
| ISNA |
| ISNONTEXT |
| ISNUMBER |
| ISODD |
| ISREF |
| ISTEXT |
| LARGE |
| LEFT |
| LEN |
| LN |
| LOG |
| LOG10 |
| LOOKUP |
| LOWER |
| MATCH |
| MAX |
| MAXA |
| MAXIFS |
| MDETERM |
| MEDIAN |
| MID |
| MIN |
| MINA |
| MINIFS |
| MINUTE |
| MINVERSE |
| MIRR |
| MMULT |
| MOD |
| MODE |
| MONTH |
| MROUND |
| NA |
| NETWORKDAYS |
| NOT |
| NOW |
| NPER |
| NPV |
| OCT2DEC |
| ODD |
| OFFSET |
| OR |
| PERCENTILE |
| PERCENTRANK |
| PERCENTRANK.EXC |
| PERCENTRANK.INC |
| PI |
| PMT |
| POISSON |
| POWER |
| PPMT |
| PRODUCT |
| PROPER |
| PV |
| QUOTIENT |
| RADIANS |
| RAND |
| RANDBETWEEN |
| RANK |
| RATE |
| REPLACE |
| REPT |
| RIGHT |
| ROMAN |
| ROUND |
| ROUNDDOWN |
| ROUNDUP |
| ROW |
| ROWS |
| SEARCH |
| SECOND |
| SIGN |
| SIN |
| SINGLE |
| SINH |
| SLOPE |
| SMALL |
| SQRT |
| STDEV |
| SUBSTITUTE |
| SUBTOTAL |
| SUM |
| SUMIF |
| SUMIFS |
| SUMPRODUCT |
| SUMSQ |
| SUMX2MY2 |
| SUMX2PY2 |
| SUMXMY2 |
| SWITCH |
| T |
| T.DIST |
| T.DIST.2T |
| T.DIST.RT |
| TAN |
| TANH |
| TDIST |
| TEXT |
| TEXTJOIN |
| TIME |
| TIMEVALUE |
| TODAY |
| TRANSPOSE |
| TREND |
| TRIM |
| TRUE |
| TRUNC |
| UPPER |
| VALUE |
| VAR |
| VARP |
| VLOOKUP |
| WEEKDAY |
| WEEKNUM |
| WORKDAY |
| XLOOKUP |
| XMATCH |
| YEAR |
| YEARFRAC |