Excel/PDF出力ではテンプレートをもとにkintoneレコードデータでセルの値を置き換えた後、計算セルの値を更新するためにシート全体を再計算します。
この再計算において、対応している関数を以下の表に掲載します。
対応していない関数を用いた場合、以下のようなエラーが発生します。
Failed to calculate some formulas. Error evaluating cell A1... The function [関数名] is not supported.
| 関数 |
|---|
| 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 |