Free Support Forum - aspose.com

XLSX to PDF - Truncation with wrap text / auto-fit on multi-line cells

We’re having an issue with.xlsx to .pdf conversion in Aspose.Cells for .NET. Whenever a cell is wrapped, auto-fit (row height), and contains multiple lines, the last line is getting truncated during conversion to .pdf.

This is present in the 17.x release, and it has also been replicated in the most recent 18.8 release.

Attached is an example workbook that produces the undesirable result and an exported pdf that demonstrates the same:

Aspose.MultilineCellTest.zip (24.0 KB)

Thanks for your feedback.

@timtow,

Thanks for your query.

I have tested the scenario using your sample file but could not reproduce issue using latest version Aspose.Cells for .NET 18.8.1. It seems that you have sent us sample file which is either re-saved by Excel or it is different version of the file for the above mentioned issue.

You may try the following sample code with the latest version and provide your feedback. It is recommended to use Worksheet.AutoFitRows(true) to autofit row height which is auto. If issue is still there, please share the sample file again which can be used to reproduce the issue.

Workbook wb = new Workbook("Aspose.MultilineCellTest.xlsx");
wb.Worksheets[0].AutoFitRows(true);
wb.Save("output.pdf", Aspose.Cells.SaveFormat.Pdf);

Here is the latest version.

output.zip (13.4 KB)