Convert Excel to PDF with default row height either 0 or not set using Aspose.Cells for .NET in C#

Hello,

When using Aspose Cells 17.11 or 18.6, I get a blank page when saving the enclosed Excel file
to PDF.

https://www.dropbox.com/s/68c0i224v5676m0/blank-page.zip?dl=0

Any help is appreciated.

@PeteLee,

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-46198 - Blank PDF created while converting XLSX to PDF

@PeteLee

We have investigated the issue and would like to update you that, default row height of sheet[“page”] is 0, and row 1 is auto height and cached row height for row 1 is not set. So the row height of row 1 is 0. Please autofit rows that are auto height. The output PDF file is attached blank-page.pdf.

        Workbook wb = new Workbook(srcFile);
        wb.Worksheets["page"].AutoFitRows(true);
        wb.Save("blank-page.pdf");

Hope, this helps a bit.

The issues you have found earlier (filed as CELLSNET-46198) have been fixed in Aspose.Cells for .NET v18.7. Please also check the document/article for your reference: Install Aspose Cells through NuGet|Documentation