Within an .xslx file with a formula in a cell that references a row greater than 65536, the XSSFFormulaEvaluator returns "Unknown error type: -60". Within a cell, I have a formula of "=SUM(A3:A70000)". This will work if I make the range below the 65536 mark. However, with it above, I get the following stack trace: java.lang.IllegalArgumentException: Unknown error type: -60 at org.apache.poi.ss.usermodel.FormulaError.forInt(FormulaError.java:131) at org.apache.poi.xssf.usermodel.XSSFCell.setCellErrorValue(XSSFCell.java:667) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.setCellValue(XSSFFormulaEvaluator.java:209) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:153) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:327) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFFormulaEvaluator.java:318) at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateAllFormulaCells(XSSFFormulaEvaluator.java:238)
Have you tried with a recently nightly build? Only there was something similar (bug #51448 IIRC) which was fixed, and that may solve this issue too
no response in a long time => resolving for now, please reopen with more information if this is still an issue