Image in header truncated when saved to PDF

Hi,

We an issue when we save Excel workbook to PDF using aspose.cells version ​​​18.2

When the document is converted to PDF, the images presents in the header are truncated. ​(only the height is reduced)

(see file in attachment) ​​

I use the code below:​​

License asposeLic = new License();
asposeLic.SetLicense(“Aspose.Total.lic”);

Workbook oBook = new Workbook(“4754-41N7VX-V1.xlsm”);
oBook.Save(“test.pdf”, SaveFormat.Pdf);​​

4754-41N7VX-V1.zip (757.1 KB)

@f.chikh.institutdeso,

Thanks for the template file and sample code.

Please try our latest version/fix: Aspose.Cells for .NET v18.9.x

I have tested your scenario/case a bit using your template file and sample code and found the images are not truncated, I can see a little difference regarding images height though but it is marginal though.

Could you try our latest version/fix (e.g v18.9.4) and if you still think it does not fit your needs, kindly do provide a screenshot comparing the output PDFs of Aspose.Cells Vs MS Excel renderer to highlight the issue, we will check it soon.
Aspose.Cells18.9.4 For .Net2_AuthenticodeSigned.Zip (4.6 MB)

Thank you for your answer.

I tried with the 18.9.4 and the height is still reduced.

I also notice the layout is broken

Untitled.jpg (71.8 KB) difference between logos
asposeto.pdf (304.3 KB) excel converted to PDF with aspose cells
excelto.pdf (456.1 KB) Excel file saved in PDF with excel

@f.chikh.institutdeso,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46373 - Hieght of image in header truncated along with broken layout during XLSM->PDF conversion

@f.chikh.institutdeso,

We have noticed that the page layout is OK. The file excelto.pdf has some problems as the paper size is 8.5x11 inch, but the paper size set in the source file is Paper A4 (8.27x11.69 inch), please see the attachment “4754-41N7VX-V1_Ms.pdf”, it is generated by Microsoft Excel 2016 on our end. 4754-41N7VX-V1_Ms.pdf (838.3 KB)

Moreover, the issue “Image in header truncated” has been fixed. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Hello Ahsani,

This result came from Microsft Excel 2016 (Save As Pdf format) or from Aspose assembly ?

If from Aspose, could you provide us the fix as soon as possible?

Best regards

@f.chikh.institutdeso,

You can expect the fix in the new few days (3-5 days or so).

Once the fixed version is available for public use, we will share the Download link here.

The issues you have found earlier (filed as CELLSNET-46373) have been fixed in Aspose.Cells for .NET v18.10. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi