Using the EventFactory approach to read an Excel workbook I get an error when processing a FormulaRecord. A similar error is reported by EFBiffViewer as seen below: Exception in thread "main" java.lang.NullPointerException at org.apache.poi.hssf.record.FormulaRecord.toString(FormulaRecord.java: 548) at org.apache.poi.hssf.dev.EFBiffViewer$1.processRecord(EFBiffViewer.jav a:93) at org.apache.poi.hssf.eventmodel.HSSFRequest.processRecord(HSSFRequest. java:173) at org.apache.poi.hssf.eventmodel.HSSFEventFactory.genericProcessEvents( HSSFEventFactory.java:208) at org.apache.poi.hssf.eventmodel.HSSFEventFactory.processEvents(HSSFEve ntFactory.java:139) at org.apache.poi.hssf.dev.EFBiffViewer.run(EFBiffViewer.java:98) at org.apache.poi.hssf.dev.EFBiffViewer.main(EFBiffViewer.java:115) The workbook has a reference to an external workbook at the point which I think is causing the problem. I have the workbook which I can forward if this would be useful.
please click create a new attachment and attach the worksheet to this bug.
Created attachment 3614 [details] Example workbook causing the problem
optimized if, external link. (notes for developers and myself)
Fixed in 2.0pre3. Comitting the excel file as a testcase.