Bug 51675

Summary: Background images cause problems in HSSF spreadsheet
Product: POI Reporter: john mcteague <john.mcteague>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Bug Depends on:    
Bug Blocks: 53010    
Attachments: Java source to replicate
Excel 2003 with background
Excel 2007 with background

Description john mcteague 2011-08-18 09:46:38 UTC
Created attachment 27400 [details]
Java source to replicate

When opening an xls file that contains a background image, modifying the xls and then saving, I get an invalid xls file when I open in excel 2007. Excel gives the error File error: data may have been lost.

The excel file opens but the background image is lost.

This does not happen with XSSF formats.

I have attached test case to replicate.
Comment 1 john mcteague 2011-08-18 09:47:07 UTC
Created attachment 27401 [details]
Excel 2003 with background
Comment 2 john mcteague 2011-08-18 09:47:23 UTC
Created attachment 27402 [details]
Excel 2007 with background
Comment 3 john mcteague 2011-08-18 09:48:34 UTC
I have tried this with 3.8-beta3 as well as 3.7 without success. This used to work in POI 3.1.
Comment 4 Evgeniy Berlog 2012-08-12 11:32:57 UTC
This problem should be fixed in trunk.

Please try with a nightly build - see download links on http://poi.apache.org/
or build yourself from SVN trunk, see http://poi.apache.org/subversion.html