https://issues.apache.org/bugzilla/show_bug.cgi?id=47415

           Summary: Reading XLS files throws RecordFormatException
           Product: POI
           Version: 3.5-dev
          Platform: Macintosh
        OS/Version: Mac OS X 10.4
            Status: NEW
          Severity: critical
          Priority: P1
         Component: HSSF
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected]


Created an attachment (id=23866)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23866)
Excel document that throws RecordFormatException

Trying to read various XLS files (example attached) created by Excel 2008 for
Mac (v. 12.1.9) using POI 3.5 beta 6 systematically throws the following
exception with :

org.apache.poi.hssf.record.RecordFormatException: Duplicate PageSettingsBlock
record (sid=0x4d)
    at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.checkNotPresent(PageSettingsBlock.java:202)
    at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.readARecord(PageSettingsBlock.java:168)
    at
org.apache.poi.hssf.record.aggregates.PageSettingsBlock.<init>(PageSettingsBlock.java:80)
    at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:221)
    at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:161)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:288)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:202)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:318)
    at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:299)
    at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:60)

POI 3.5 beta 5 had no problem with these files. The same document in XLSX
format reads just fine.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]

Reply via email to