Hi, I am having trouble with the anchor type when I am adding images to an excel file. The point is that I would like to use the autofilter function within Excel, which requires the images to be positioned in a way that they are allowed to be resized and moved with a cell.
I thought, the anchor type would take care of this. I tried the following code ClientAnchor anchor = helper.createClientAnchor(); anchor.setCol1(col); anchor.setRow1(row); anchor.setAnchorType(ClientAnchor.MOVE_AND_RESIZE); then adding the images as described in the examples. The images appear as expected, the cell size is calculated and adjusted to the image size, but when I click on "Size and Properties" of the image, the positioning of the object (second tab) is still set to "depend only on cell position" instead on "depend on cell position and size" (the translation might be not entirely correct, since I don't have the english version of Excel). Of course, I also tried the other anchor types, no effect there. Did I miss anything? Cheers, Hannes --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
