Please add support for the function 'TRUNC'. Caused by: org.apache.poi.ss.formula.eval.NotImplementedException: TRUNC at org.apache.poi.hssf.record.formula.functions.NotImplementedFunction.evaluate(NotImplementedFunction.java:42) at org.apache.poi.hssf.record.formula.eval.FunctionEval.evaluate(FunctionEval.java:247) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:374) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:257) ... 45 more
TRUNC is implemented in 3.8-beta3. Yegor