Bug 50458

Summary: Images in XLSX files behave strange in Excel 2007
Product: POI Reporter: Johan <johan>
Component: XSSFAssignee: POI Developers List <dev>
Severity: normal CC: raimy69
Priority: P2    
Version: 3.7-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
URL: http://apache-poi.1045710.n5.nabble.com/Images-and-XSSF-unexpected-results-tc3300963.html
Attachments: Faulty output!
A little program which reproduces the error

Description Johan 2010-12-11 14:11:03 UTC
Created attachment 26393 [details]
Faulty output!

Xlsx file containing 2 images and one textbox gives strange result when I try dragging the images/textbox around in xl.

In Excel 2007 when dragging one image and releasing it the two images change places. And if I stretch the textbox it becomes an Image! 

Works ok if I open in OpenOffice 3.2

A fellow told me that the file didn't work in Excel 2008 but works in 2010.

If I code the same thing with HSSF it works ok.
Comment 1 Johan 2010-12-11 14:14:20 UTC
Created attachment 26394 [details]
A little program which reproduces the error

This code produced the faulty xlsx file
Comment 3 Ray O'Hagan 2011-06-12 23:19:25 UTC
also having the same issue, works fine in HSSF but moving any image around the sheet (when there is more than one image on the sheet) causes the images to switch places, or randomly change to other images on the sheet.
Comment 4 Yegor Kozlov 2011-06-13 11:58:41 UTC
Should be fixed in r1135103

Inserted shapes had the same shapeId=1. That bewildered Excel when moving / dragging the drawing objects.