HI, dear POI dev team. I'v got a VERY VERY SIMPLE AND EMPTY Excel file, ONLY ONE sheet and NOTHING in the sheet.(I do not known how the excel file was be created,It just come from my customer), And when I use new HSSFWorkbook(fs) , it will threw a exception: (but poi2.5 will WORK FINE with my poor excel files.) ---------------------------------------- org.apache.poi.hssf.record.RecordFactory.createRecord() RecordFactory.java:189 org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents() HSSFEventFactory.java:174 org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents() HSSFEventFactory.java:101 org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance ---------------------------------------- And when I ues the newest poi-source-3.0-alpha3-20070205.zip try to finding the error point,I got the following infomation: --------------------------------------- In method of Pta.createPtg(RecordInputStream in) when switch (id), the id was -59 ,so it goto default : and throw new java.lang.UnsupportedOperationException(" Unknown Ptg in Formula: 0x"+Integer.toHexString(( int ) id) + " (" + ( int ) id + ")"); how can i upload my poor excel file? your laoguo
Created attachment 19523 [details] only one sheet ,and nothing in the sheet.of cause no any macro.
HI, I HAVE UPLOAD MY POOL EXCEL FILE NAMED 1.xls. thanks first.
Same issue here! MY xls file is not as simple as 1.xls. Its a real world xls file. (Let me know if you would like me to attach it). Just upgraded my java app to poi-3.0-alpha3-20061212 This file used to work in poi-final-2.5.1 I will attach the stacktrace.
Created attachment 19623 [details] Stacktrace of the issue
the name definition (named range) causes this problem.
Dear POI Team, I also have this issue with a single sheet XLS file from a customer. I was using 3.0.2-FINAL release, but had to revert to 3.0.1-FINAL release for it to work again. I made a spreadsheet that is basically the same as the one that is causing the problem that I would be happy to provide if you need some test data. Since 3.0.1-FINAL works just fine, it's not a critical thing for me (though some of the new function evaluation code would come in handy). Thanks for your time. I love your product - great work!
I've just tried the attached spreadsheet, and it opens just fine with svn trunk I've added a new test to the test suite, so we can ensure this doesn't get broken again in future