Bug 51675 - Background images cause problems in HSSF spreadsheet
Summary: Background images cause problems in HSSF spreadsheet
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Blocks: 53010
  Show dependency tree
Reported: 2011-08-18 09:46 UTC by john mcteague
Modified: 2012-08-12 11:32 UTC (History)
0 users

Java source to replicate (857 bytes, text/x-java)
2011-08-18 09:46 UTC, john mcteague
Excel 2003 with background (67.50 KB, application/vnd.ms-excel)
2011-08-18 09:47 UTC, john mcteague
Excel 2007 with background (14.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-08-18 09:47 UTC, john mcteague

Note You need to log in before you can comment on or make changes to this bug.
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