Please find attached a sample application (VB.Net) including all examples etc. that demonstrates the issue.
The general issue is, that images resize when autowrap of a cell in a row that is covered by the image is set to true.
Basically, what happens is:
1.) Open “input.xlsx”
2.) Add picture “input.png”
3.) Save the workbook as “output.xlsx”
4.) Set text wrap and text content of a cell
5.) Save the workbook as “output.xlsx”
If you run this code, you will see that the image is perfectly fine in the output! Now comment out the 3rd step (= the first save of the workbook) and run again - you will see the the image is (somehow) vertically stretched. This does NOT happen, if textwrap is not set, so it has something to do with the textwrap.
If I add the picture AFTER setting the textwrap settings (that is not included in the attached sample application), then the image is stretched as well.
I need a consistent behaviour, where - when I add a picture with a given heightscale and widthscale - it never changes its size and provides reliable output.
Thanks for your help,
AsposeTester.zip (4.7 MB)