You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/03/12 08:04:58 UTC

DO NOT REPLY [Bug 46840] New: Can't open Office 97 XLS which has been edited with Office 2007

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: dev@poi.apache.org
        ReportedBy: t.prochazka@centrum.cz


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46840] Can't open Office 97 XLS which has been edited with Office 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46840





--- Comment #1 from Tomas Prochazka <t....@centrum.cz>  2009-03-12 00:05:30 PST ---
Created an attachment (id=23374)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=23374)
XLS which has been open, edited and the saved in O2007

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 46840] Can't open Office 97 XLS which has been edited with Office 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46840


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #2 from Josh Micich <jo...@gildedtree.com>  2009-03-23 12:49:13 PST ---
Fixed in svn r757520 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=757520 )junit added

Excel 2007 adds an extra page settings record, HEADERFOOTER(0x089C), which POI
didn't process properly.

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org