thanks a lot Yegor! Avinash
-----Original Message----- From: Yegor Kozlov [mailto:[email protected]] Sent: Saturday, March 21, 2009 9:29 AM To: POI Users List Subject: Re: Anchor type methods in XSSF added in r756965 Daily builds can be downloaded from http://encore.torchbox.com/poi-svn-build/ Regards, Yegor > thanks Yegor! > > I think it will be really helpful. > > Regards > A > > -----Original Message----- > From: Yegor Kozlov [mailto:[email protected]] > Sent: Wednesday, March 18, 2009 11:29 AM > To: POI Users List > Subject: Re: Anchor type methods in XSSF > > XSSFClientAnchor is really missing this feature. > When constructing XSSFPicture the resizing behavior is hardcoded to "Move > With Cells but Do Not Resize". > See XSSFDrawing.createShape: > > public XSSFPicture createPicture(XSSFClientAnchor anchor, int > pictureIndex) > { > PackageRelationship rel = addPictureReference(pictureIndex); > > CTTwoCellAnchor ctAnchor = createTwoCellAnchor(anchor); > ctAnchor.setEditAs(STEditAs.ONE_CELL); //should be taken from > XSSFClientAnchor ! > CTPicture ctShape = ctAnchor.addNewPic(); > ctShape.set(XSSFPicture.prototype()); > > XSSFPicture shape = new XSSFPicture(this, ctShape); > shape.anchor = anchor; > shape.setPictureReference(rel); > return shape; > } > > I will try to find time to add this support. > > Yegor > >> Hi >> >> I am trying to fit different size images and text in the same column or row >> The key goal is to maintain the image widths and height across the rows and >> columns >> but size the col width to the biggest image width. >> >> This was easy to achieve in HSSF because the HSSFClientAnchor class had a >> setAnchorType >> method which I could set a value to "2" and the image would move with the >> cell and it would >> not resize itself as the cell size is changed. >> >> In XSSFClientAnchor there is no such method and I am really hurting because >> of this. I have substantaial code >> written out in XSSF which I don't want to change to HSSF and also we want to >> support the newer Excel files. >> >> Can someone with knowledge of image resizing please tell me why this feature >> is gone and if there is a workaround for this in >> the XSSf implementation. I did not see any examples for this in the code >> base.I am using v3.5 beta4. >> I think it was a really useful feature and would really like to see >> something like this in XSSF . >> >> Any help/cpmments/pointers are really appreciated. >> >> Regards >> A >> >> >> >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
