https://issues.apache.org/bugzilla/show_bug.cgi?id=51520
Bug #: 51520
Summary: XSSFFormulaEvaluator fails if formula references row
above 65536
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
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)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
