Based on what you said, it looks like POI hasn't implemented the IFERROR function yet. Could you please open an enhancement request on bugzilla?
https://bz.apache.org/bugzilla/enter_bug.cgi?product=POI&component=SS%20Common The documentation for the IFERROR function is https://support.office.com/en-us/article/IFERROR-function-c526fd07-caeb-47b8-8bb6-63f3e417f611 On Aug 3, 2017 09:37, "Hehabr" <[email protected]> wrote: > Formulas in a Excel-file > : > AND, FALSE, IF, IFERROR, MAX, OR, SUM, SUMPRODUCT, VLOOKUP > > Formulas in Program with > System.out.println(FunctionEval.getSupportedFunctionNames()); > : > [ABS, ACOS, ACOSH, ADDRESS, AND, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, > AVERAGE, CEILING, CHAR, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, > CONCATENATE, COS, COSH, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, DAY, > DAYS360, DEGREES, DEVSQ, DGET, DMIN, DOLLAR, ERROR.TYPE, EVEN, EXACT, EXP, > FACT, FALSE, FIND, FIXED, FLOOR, FV, HLOOKUP, HOUR, HYPERLINK, IF, INDEX, > INDIRECT, INT, INTERCEPT, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISLOGICAL, > ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, LARGE, LEFT, LEN, LN, LOG, LOG10, > LOOKUP, LOWER, MATCH, MAX, MAXA, MEDIAN, MID, MIN, MINA, MINUTE, MIRR, MOD, > MODE, MONTH, NA, NOT, NOW, NPER, NPV, ODD, OFFSET, OR, PERCENTILE, PI, PMT, > POISSON, POWER, PPMT, PRODUCT, PROPER, PV, RADIANS, RAND, RANK, RATE, > REPLACE, REPT, RIGHT, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, SEARCH, > SECOND, SIGN, SIN, SINH, SLOPE, SMALL, SQRT, STDEV, SUBSTITUTE, SUBTOTAL, > SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, T, TAN, TANH, > TEXT, TIME, TODAY, TRIM, TRUE, TRUNC, UPPER, VALUE, VAR, VARP, VLOOKUP, > WEEKDAY, YEAR] > > > IFERROR is missing in Java... Why? ( My apache.poi.version is 3.16 ) > > > > > -- > View this message in context: http://apache-poi.1045710.n5. > nabble.com/Apache-POI-How-to-update-excel-file-with-many- > formulas-tp5728410p5728413.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
