DO NOT REPLY [Bug 27153] New: - Graphics resized when altering column widths

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=27153>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=27153

Graphics resized when altering column widths

           Summary: Graphics resized when altering column widths
           Product: POI
           Version: 3.0-dev
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: timw@mediatel.co.uk
                CC: danny@muibros.com


I have noticed a bug with POI 2.0 final release when dealing with excel sheets
that contain images and involving resizing columns on which the image spans.

I set the graphics properties to be independent of the cell's size and position.
Which causes the object to stay at its size even if I resize the column. This
does not work with HSSF. The graphic is being resized to column width but the
properties remain unchanged.

I have included a simple program example of this. This involves taking an excel
document as a template (ImageResizeExampleTemplate.xls) that contains an image
in the top left corner. The program takes this excel document template (it looks
for it on the root of your class path) and alters the 'A' column width to be
much wider than in the original. Finally the program creates a new excel
document (ImageResizeExampleOutput.xls) with the modified work book object.

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