On 27/09/2011 21:52, Jim Talbut wrote:
On 27/09/2011 11:14, Jim Talbut wrote:
Hi,
I'm adding three pictures to an XLSX sheet and the result is rather
odd - the pictures all look correct in Excel, but when I try to move
one of them (in Excel) it moves the wrong picture.
i.e. I drag Picture 3 to a new location and Picture 1 appears there
at Pictures 3's size.
Is this something obvious that I'm doing wrong?
Looking into this further I tried saving one copy of a sample XLSX
file from Excel and comparing that with a fresh one generated by POI
(in this isntance there are two pictures in the file).
I think (without having much clue what I'm talking about) that the
problem lies with
/xdr:wsDr/xdr:twoCellAnchor/xdr:pic/xdr:nvPicPr/xdr:cNvPr/@id
For the file corrected by Excel the two instances of
/xdr:wsDr/xdr:twoCellAnchor have different values for
/xdr:wsDr/xdr:twoCellAnchor/xdr:pic/xdr:nvPicPr/xdr:cNvPr/@id ("2" and
"3", if it matters what the actual values are), but for the POI file
they are both "1".
Ah, moving to v3.8-beta4 fixes this problem, but unfortunately I'm now
affected by bug 51236
(https://issues.apache.org/bugzilla/show_bug.cgi?id=51236).
If I can do anything to help someone work out a fix for that please let
me know.
I guess I'll just have to special case my font colours until that gets
fixed.
Jim
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
