Rob Y wrote: > > I'm trying to put status flag pictures into XLS cells, and have it kind of > working. But there's a problem. On certain columns, I have the cell > wrapping attribute set. So on the rows where there's enough text in those > cells to actually wrap, my pictures get stretched to the cell height. > > I could probably set the row height explicitly, but I think that would > prevent Excel from automatically wrapping text. It looks like a catch-22. > >
Tried explicitly setting the row height, and as I suspected, that fixes the picture sizing, but it also prevents auto-wrapping from working (Excel doesn't resize size the rows to fit the wrapping text, and you only end up seeing the first line of the text). If you then manually resize the row you'll see all of the wrapping text, and the picture will not be stretched (I use anchor type 2). But that's a big pain. What I don't get is that with anchor type 2, Excel maintains the original size of the picture regardless of how you resize the anchor cell(s). How can it do that if the only sizing mechanism is the anchor itself, which is relative to the cell(s)? The only way I can think of (short of there being another record type or option that POI doesn't support) is for Excel to dynamically adjust all anchors whenever you resize a row (or column) that could affect those anchors. Never underestimate the horribleness of the XLS file format or the lengths Microsoft will go to to hide that awfulness from you, but seriously. Do we really think Excel does all that on every resize operation? And if they do go through that, why don't they do it for auto-wrapping too? In the case of auto-wrapping, I guess POI leaves the row height set at -1 (default) and excel replaces that with the results of auto-wrapping. Any anchors that include that default height row must have been set up with that height in mind, so when Excel enlarges the row, it ought to fix the anchors just like it does when you manually enlarge the row. I just don't get it. -- View this message in context: http://www.nabble.com/Ouch---pictures-%2B-wrapping-%3D-stretched-pictures-tp20964770p20981309.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
