Bug 57214 - Image getting shrunk when column width is decreased using POI API
Summary: Image getting shrunk when column width is decreased using POI API
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2014-11-14 09:50 UTC by ankit
Modified: 2015-03-22 22:05 UTC (History)
0 users

unzip the attachment to get 3 files (260.19 KB, application/zip)
2014-11-14 09:50 UTC, ankit

Note You need to log in before you can comment on or make changes to this bug.
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?