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: [email protected]
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
