This problem occurs on a spreadsheet that has cells that have data validation from a drop down list. The error occurs when one of the drop down list cells is selected on the spreadsheet. If any other cell is selected, the spreadsheet can be processed without a problem. I would attach the spreadsheet that causes the error, but I don't see that option provided in Bugzilla. I can mail the spreadsheet to the owner of this bug upon request. Here is the error that occurs: org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:237) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:160) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:165) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:132)
Created attachment 12063 [details] Spreadsheet that causes the error described. Notice that the selected cell is a drop down list validation cell.
Created attachment 16586 [details] With this File the Bug can be simulated. With this File the Bug can be simulated.
There's a new file submited where the error can be simulated.
I have seen if you select all cells after touching or editing drop downs and save, the excel is readable. could be temporary fix until the bug is fixed. (In reply to comment #0) > This problem occurs on a spreadsheet that has cells that have data validation > from a drop down list. The error occurs when one of the drop down list cells > is selected on the spreadsheet. If any other cell is selected, the spreadsheet > can be processed without a problem. > > I would attach the spreadsheet that causes the error, but I don't see that > option provided in Bugzilla. I can mail the spreadsheet to the owner of this > bug upon request. > > Here is the error that occurs: > > org.apache.poi.hssf.record.RecordFormatException: Unable to construct record > instance, the following exception occured: null > at org.apache.poi.hssf.record.RecordFactory.createRecord > (RecordFactory.java:237) > at org.apache.poi.hssf.record.RecordFactory.createRecords > (RecordFactory.java:160) > at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> > (HSSFWorkbook.java:165) > at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> > (HSSFWorkbook.java:132)
Works as of 12Jan2007, Testcase added. http://issues.apache.org/bugzilla/show_bug.cgi?id=41366