https://issues.apache.org/bugzilla/show_bug.cgi?id=49156
Summary: NPE when evaluateInCell is used
Product: POI
Version: 3.7-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
During evaluation of formulas using FormulaEvaluator's evaluateInCell(cell) -
getting the following NPE. Using evaluateFormulaCell(cell) instead - no such
problem. It occurs on complex spreadsheets and I was not able to reproduce the
exception reading the same formulas from the same spreadsheets individually.
So, it may be happening as a side effect of sequential bulk reading of a bunch
of formulas (probably in combination with some styles?). Looks like a caching
problem somewhere inside the framework. I'm using the most recent, yesterday's
snapshot (20100419), - to avoid 48026 and few following exceptions.
java.lang.Class - java.lang.NullPointerException
at
org.apache.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:369)
at org.apache.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:353)
at
org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:141)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:259)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:207)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:252)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:173)
at
org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateInCell(XSSFFormulaEvaluator.java:46)
at
org.is.jxlpoi.JXLPOIWorkbook.getCellContentAsString(JXLPOIWorkbook.java:137)
--
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]
