| Summary: | ClassCastException in evaluateFormulaCell | ||
|---|---|---|---|
| Product: | POI | Reporter: | Emmanuel F <e.fougeras> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | critical | ||
| Priority: | P1 | ||
| Version: | 3.0-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Windows Vista | ||
| Attachments: | Testcase | ||
Please upload the problem excel file, so we can take a look and see what POI is doing wrong (the stacktrace shows something happening that ought not to) Created attachment 21870 [details]
Testcase
The problem excel file is in attachments. Just tried on svn trunk, and works just fine, no exception. Test added to svn verifies this Please retry with 3.1 beta 1 (should be on mirrors shortly) or a svn nightly build. |
Tested with poi-3.0.2-FINAL java.lang.ClassCastException: org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate cannot be cast to org.apache.poi.hssf.record.LabelSSTRecord at org.apache.poi.hssf.usermodel.HSSFCell.setCellValue(HSSFCell.java:625) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:253) My code : private final void updateAllFormulas(final HSSFWorkbook parWorkbook) { final int locNumberOfSheets = parWorkbook.getNumberOfSheets(); for (int locSheetNum = 0; locSheetNum < locNumberOfSheets; locSheetNum++) { final HSSFSheet locSheet = parWorkbook.getSheetAt(locSheetNum); final HSSFFormulaEvaluator locEvaluator = new HSSFFormulaEvaluator(locSheet, parWorkbook); for (final Iterator locSheetIter = locSheet.rowIterator(); locSheetIter.hasNext();) { final HSSFRow locRow = (HSSFRow) locSheetIter.next(); locEvaluator.setCurrentRow(locRow); for (final Iterator locCellIter = locRow.cellIterator(); locCellIter.hasNext();) { final HSSFCell locCell = (HSSFCell) locCellIter.next(); if (locCell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) { locEvaluator.evaluateFormulaCell(locCell); } } } } }