We have several programs that we use to e-mail spreadsheets to our users. The majority of them contain images, which are confined to fit in one cell (the row height is set in the program to be 4000 (SSRow_setHeight(row: 4000). The process works fairly well for us - the images are all reduced to fit the cells, maintaining the aspect ratio.
We are presently using .xls format.
I'm attempting to change to .xlsx format - all works well, except for the images.
The following lines of code work properly when writing to .xls. When writing to .xlsx, the images don't even appear at all, or appear as one or two pixels. Changing the first 5 parameters from book: 0: 0: 0: 0: to book & non-zeros values results in the images appearing, but doesn't retain aspect ratio.
IBM i 7.1
java version "1.6.0"
Java(TM) SE Runtime Environment (build pap3260sr11-20120806_01(SR11))
IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 OS/400 ppc-32 jvmap3260sr11-20120806_01 (JIT enabled, AOT enabled)
J9VM - 20120801_118201
JIT - r9_20120608_24176ifx1
GC - 20120516_AA)
JCL - 20120713_01
Any advise is appreciated. Thanks
<p>Pic = pathname;<br />
r = rowcounter;<br />
idx = SS_addPicture(book: Pic: SS_PIC_JPEG);<br />
Anc = new_SSClientAnchor( book: 0: 0: 0: 0: 0: r: 0: r);<br />
SSClientAnchor_setAnchorType(Anc: SS_ANCHOR_MOVE);<br />
img = SSDrawing_createPicture(Drw: anc: idx);<br />