|Summary:||Images in XLSX files behave strange in Excel 2007|
|Component:||XSSF||Assignee:||POI Developers List <dev>|
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 2 Johan 2010-12-11 14:15:07 UTC
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.