You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2010/12/11 20:11:09 UTC

DO NOT REPLY [Bug 50458] New: Images in XLSX files behave strange in Excel 2007

https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

           Summary: Images in XLSX files behave strange in Excel 2007
           Product: POI
           Version: 3.7
          Platform: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: johan@risken.se


Created an attachment (id=26393)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26393)
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.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 50458] Images in XLSX files behave strange in Excel 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

--- Comment #1 from Johan <jo...@risken.se> 2010-12-11 14:14:20 EST ---
Created an attachment (id=26394)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26394)
A little program which reproduces the error

This code produced the faulty xlsx file

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 50458] Images in XLSX files behave strange in Excel 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

Johan <jo...@risken.se> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                URL|                            |http://apache-poi.1045710.n
                   |                            |5.nabble.com/Images-and-XSS
                   |                            |F-unexpected-results-tc3300
                   |                            |963.html
         OS/Version|                            |All

--- Comment #2 from Johan <jo...@risken.se> 2010-12-11 14:15:07 EST ---
http://apache-poi.1045710.n5.nabble.com/Images-and-XSSF-unexpected-results-tc3300963.html

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 50458] Images in XLSX files behave strange in Excel 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

--- Comment #3 from Ray O'Hagan <ra...@gmail.com> 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.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 50458] Images in XLSX files behave strange in Excel 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #4 from Yegor Kozlov <ye...@dinom.ru> 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.

Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 50458] Images in XLSX files behave strange in Excel 2007

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50458

Ray O'Hagan <ra...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |raimy69@gmail.com

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org