AutofitRows results in clipped text in PDF conversion output

Aspose.Cells Product Family
,
1

Hi, I’m using Aspose.Cells to autofit row heights that are not customed in an Excel file and then convert the Excel file into a PDF file, and in the PDF output, the text is clipped for all rows. However, when I use Excel to autofit all row heights and then print to PDF, the text is not clipped. I’ve attached the Excel input file excelinput.zip (26.7 KB), the Aspose-generated PDF output asposepdf.pdf (42.5 KB), and the Excel-generated PDF for comparison excelpdf.pdf (210.6 KB). Is there anyway to get the same output using Aspose?

Here is the code I am using:

foreach (Worksheet worksheet in _workbook.Worksheets)
{
worksheet.AutoFitRows(true);
}
_workbook.Save(outputPath, SaveFormat.Pdf);

2

@sdonapati

I reproduce the issue as you mentioned: the text is clipped in the output pdf after AutoFitRows(true) . I have logged a ticket with an id “CELLSNET-52367” for your issue. We will look into the details of the problem soon.

Once we have an update on it, we will let you know.

3

@sdonapati,

This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v22.12) which is scheduled in the first half of December 2022. You will be notified once the next release is published.

4

The issues you have found earlier (filed as CELLSNET-52367) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi