We are having a big problem with an image within an excel file. Every time the excel is re-saved, the image is getting bigger.
I have attached a mini project to demonstrate this bug. This generates two files; an excel and pdf file.
Please run the project and select the attached excel file “test5.xlsx” when the file open dialog window appears.
If you check the image’s size in the input file “test5.xlsx”, the size is Height: 100% and Width: 100%.
If you look at the output file “generated file.xlsx”, the size has changed (more significantly the width). This is a problem when the file will be resaved multiple times as it may be edited more than once.
- The size is increased as the workbook has been opened using; after the following line.
Workbook wb = new Workbook(…);
- The size is also increased when you call wb.Save(…); I tried forcing a re-size right before the save to 100% by 100% and the resultant file still contains the image resized to be larger.