Raised as a bug: https://issues.apache.org/bugzilla/show_bug.cgi?id=54316
On 12 December 2012 18:12, Jan Stette <[email protected]> wrote: > 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 >
