Bug 43055 - Saving Excel sheet generated by Crystal Reports
Summary: Saving Excel sheet generated by Crystal Reports
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-FINAL
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-07 11:16 UTC by Petr Titera
Modified: 2007-08-23 10:40 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Petr Titera 2007-08-07 11:16:54 UTC 
When you save Excel workbook generated by Crystal Reports, this workbook will
become unreadable by OpenOffice. Problem is, that Crystal Reports are generating
'Workbook' stream as 'WORKBOOK'. Loading of such worksheets is allready fixed in
current version (see HSSFWorkbook(POIFSFileSystem fs, boolean preserveNodes)).

Problem is that in HSSFWorkbook.write new stream 'Workbook' is added to
POIFSFileSystem object without skipping wrongly named one.

Because of this resulting file will have TWO workbook streams.

In my opinion fix would be to add "WORKBOOK" to list of exceptions which are not
copied.
Comment 1 Nick Burch 2007-08-23 10:40:46 UTC 
Thanks for the suggestion. This is now in svn.