Hi all.
I'm desperate.
I want to modify an excel xlxs file, inserting images in column 0 of all rows.
That file has several cols an rows with data. Col 0 for imagez, col is used to obtain the file name of the image.
I can read the file correctly, resize rows for write the images and save back the file. When i open the file with libreoffice calc , the images are distorted in height, also the height of them is growing with the row number. The height of image in row 0 its almost correct, in row 1 is a little bigger, in row 2 a little more bigger an so...the last image is enormous in height.
If i read the original file to obtain filenames of images and insert images in a new tworkbook, and save it, the result is ok. All images are correctly in size, position and scale. If i write somedata more, p.e. the filename of image in col 1, and save the new file, the images are wrong sized(in heigh) again.
I workarround playing whith y-scale, but its is relative to the height of the row
If scale value is greater than 0.12 the image is escaled, but if it is lower, then the image height is set to the scale value.
This behaviour is the same if the result file is .ods or .xlxs
Help, help....i dont understand nothing.
Regards