Bug 57214

Summary: Image getting shrunk when column width is decreased using POI API
Product: POI Reporter: ankit <ankitrungta001>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: unzip the attachment to get 3 files

Description ankit 2014-11-14 09:50:12 UTC
Created attachment 32205 [details]
unzip the attachment to  get 3 files

I have attached 3 files:
1) Program which is used to compress width of a column if it exceeds given limit.
2) Input excel file.
3) Output excel file.

When i shrunk the column width manually from excel then image is not shrunk, but when i do the same using POI image is getting shrunk.
If you observe the output excel properly, an image in output excel has got shrunk to size zero because of which it got totally disappeared.
Comment 1 Andreas Beeker 2014-11-14 14:22:38 UTC
Up till now, images are anchored with a TwoCellAnchor, i.e. the starting col/row (incl. delta x/y coords within the cell) and same for the ending col/row.
I think (it's already sometime ago, that I've tried it ...) if you manually introduce a OneCellAnchor, it will be independent from the ending row.

Maybe we should introduce some helper method to convert twocell to onecell anchor ...?
Comment 2 ankit 2014-11-17 06:06:35 UTC
Seems right for my case.
How long you think it would take to get a fixed version from your side?

Can you tell me if there is a workaround for this problem that i can implement?
My simple requirement is that i need to decrease the width of a column,keeping everything else intact.
Comment 3 ankit 2014-11-20 10:30:45 UTC
It might not be a priority but the only concern i have here is what is the max timeline it would take for this issue to be resolved.

I just want to make sure that this issue doesn’t go on hold forever.

So say if I want to wait to get a fix for this issue.
Then, based on your priorities, please tell me a rough expectation of when this issue will get fixed?