https://issues.apache.org/bugzilla/show_bug.cgi?id=46840
Summary: Can't open Office 97 XLS which has been edited with
Office 2007
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=23373)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=23373)
Original file from Office 97
I have .XLS file which I can normally open by POI library. I opened it in
Office
2007, replace one column with another data and dave it.
And now I get the this exception from POI:
Exception in thread "main" java.lang.RuntimeException: two Page Settings Blocks
found in the same sheet
at org.apache.poi.hssf.model.Sheet.<init>(Sheet.java:228)
at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:287)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:201)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:317)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
at
cz.atomsoft.actum.carrefour.carrefourhelper.tasks.XlsToAccessConverter.convert(XlsToAccessConverter.java:81)
at
cz.atomsoft.actum.carrefour.carrefourhelper.tasks.XlsToAccessConverter.convert(XlsToAccessConverter.java:73)
at
cz.atomsoft.actum.carrefour.carrefourhelper.tasks.XlsToAccessConverter.searchFolderAndConverAllFiles(XlsToAccessConverter.java:68)
at
cz.atomsoft.actum.carrefour.carrefourhelper.tasks.XlsToAccessConverter.process(XlsToAccessConverter.java:54)
at cz.atomsoft.actum.carrefour.carrefourhelper.App.main(App.java:31)
I tested it with two different documents. Interesting is, that when I create
new document in Office 2007 and save it in compatibility mode, it works.
Problem is only when I open old Office XLS and then save it.
--
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]
