Sorry for the mistake in my reply above, there is no such thing as a
'CRDrawing bean', that should have read 'CTDrawing bean' of course.
You do have one other option if all you need to do is move images around on
the worksheets or resize them. It is possible to use core java code to unzip
the workbook, open the relevant xml file - called 'drawingN.xml' where N is
an integral value such as 1, 2, etc - and then manually modify the markup
before saving those changes and re-zipping the results. This morning, I had
the chance to play with some code and found that simply changing this piece
of markup
- <xdr:from>
<xdr:col>1</xdr:col>
<xdr:colOff>0</xdr:colOff>
<xdr:row>1</xdr:row>
<xdr:rowOff>0</xdr:rowOff>
</xdr:from>
- <xdr:to>
<xdr:col>4</xdr:col>
<xdr:colOff>0</xdr:colOff>
<xdr:row>9</xdr:row>
<xdr:rowOff>114300</xdr:rowOff>
</xdr:to>
to this
- <xdr:from>
<xdr:col>0</xdr:col>
<xdr:colOff>0</xdr:colOff>
<xdr:row>0</xdr:row>
<xdr:rowOff>0</xdr:rowOff>
</xdr:from>
- <xdr:to>
<xdr:col>4</xdr:col>
<xdr:colOff>0</xdr:colOff>
<xdr:row>9</xdr:row>
<xdr:rowOff>114300</xdr:rowOff>
</xdr:to>
resulted in the image being moved on the worksheet.
If you feel able, patching the API so that it is possible to use XSSF to
manipulate images in this manner would, I am confident, be something many
users would welcome and appreciate.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Does-XSSFDrawing-support-a-function-like-getChildren-in-HSSFPatriarch-tp3230572p3232065.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]
