You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/12/17 10:16:37 UTC
[Bug 54316] New: NullPointerException when reading spreadsheet with
external reference
https://issues.apache.org/bugzilla/show_bug.cgi?id=54316
Bug ID: 54316
Summary: NullPointerException when reading spreadsheet with
external reference
Product: POI
Version: 3.9-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
Assignee: dev@poi.apache.org
Reporter: jan.stette@gmail.com
Classification: Unclassified
I'm seeing a NullPointerException when trying to read an HSSF spreadsheet using
POI 3.9.0. The error happens here:
ExternSheetNameResolver.prependSheetName(FormulaRenderingWorkbook, int, String)
line: 34
Ref3DPtg.toFormulaString(FormulaRenderingWorkbook) line: 91
FormulaRenderer.toFormulaString(FormulaRenderingWorkbook, Ptg[]) line: 92
HSSFFormulaParser.toFormulaString(HSSFWorkbook, Ptg[]) line: 83
HSSFCell.getCellFormula() line: 621
Debugging it, I see in ExternSheetNameResolver.prependSheetName() that the
sheet name coming back from the ExternalSheet object is null. (This comes from
LinkTable.getExternalBookAndSheetName(), where shIx gets the value -1).
The spreadsheet in question has a couple of external references of the form
'NNNN.xls'#$''.D1, which is where the error occurs. (I'm unfortunately not able
to attach the spreasheet as it contains confidential information)
--
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
[Bug 54316] NullPointerException when reading spreadsheet with
external reference
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=54316
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution|--- |LATER
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
I believe this has been solved in 3.11 beta 1, with the various updates to how
external spreadsheets are supported
If the problem still remains for you with 3.11, please create a simple excel
file which shows the problem, and an associated small junit unit test, and
re-open the bug.
--
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