XSSFEvaluationWorkbook.getSheet can throw ArrayIndexOutOfBoundsException
Andreas Reichel <[email protected]> Sat, 30 Oct 2021 17:20:41 +0700
| Newsgroups | gmane.comp.jakarta.poi.user |
|---|---|
| Message-ID | <3ba325ff2f2840d00574b561dac8e98c5c17a5e3.camel@manticore-projects.com> |
Greetings POI team.
Using Apache POI 5.0 I would like evaluate all Cells in order to auto-
size all columns in all sheets:
FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
for (int i =0; i<sheetParameters.length; i++) {
Sheet sheet = workbook.getSheetAt(i);
for (Row r : sheet) {
for (Cell c : r) {
if (c.getCellType() == CellType.FORMULA) {
try {
// this can throw an ArrayIndexOutOfBoundsException
// at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getSheet(XSSFEvaluationWorkbook.java:77)
evaluator.evaluateFormulaCell(c);
} catch (Exception ignore) {
}
}
}
}
for (int k=0; k<=CAPTIONS.length; k++)
sheet.autoSizeColumn(k);
}
To my surprise this can throw an Exception:
java.lang.ArrayIndexOutOfBoundsException: Index 8 out of bounds for length 8
at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getSheet(XSSFEvaluationWorkbook.java:77)
at org.apache.poi.ss.formula.WorkbookEvaluator.getSheet(WorkbookEvaluator.java:117)
at org.apache.poi.ss.formula.SheetRefEvaluator.getSheet(SheetRefEvaluator.java:53)
at org.apache.poi.ss.formula.SheetRefEvaluator.getEvalForCell(SheetRefEvaluator.java:48)
at org.apache.poi.ss.formula.SheetRangeEvaluator.getEvalForCell(SheetRangeEvaluator.java:74)
at org.apache.poi.ss.formula.LazyRefEval.getInnerValueEval(LazyRefEval.java:39)
at org.apache.poi.ss.formula.eval.OperandResolver.chooseSingleElementFromRef(OperandResolver.java:217)
at org.apache.poi.ss.formula.eval.OperandResolver.getSingleValue(OperandResolver.java:67)
at org.apache.poi.ss.formula.eval.UnaryMinusEval.evaluate(UnaryMinusEval.java:38)
at org.apache.poi.ss.formula.functions.Fixed1ArgFunction.evaluate(Fixed1ArgFunction.java:33)
at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:140)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:541)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:275)
at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:216)
at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:56)
at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluateFormulaCell(BaseFormulaEvaluator.java:184)
at com.manticore.etl.custom.UBASecurityDetails.buildReport(UBASecurityDetails.java:600)
at com.manticore.etl.custom.UBASecurityDetails.main(UBASecurityDetails.java:334)
Should I open an Ticket on that or am I doing something wrong?
Thanks and warm regards
Andreas