poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49156] New: NPE when evaluateInCell is used
Date Tue, 20 Apr 2010 13:43:20 GMT
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: dev@poi.apache.org
        ReportedBy: vgavr@rogers.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message