Converting to PDF will cut text from output

Aspose.Cells Product Family
1

I am converting Excel xlsx file to PDF and output is unusable.

Attached file is simplest testcase and related output.

Code:

var book = new Workbook(“lipsum.xlsx”);
book.Save(@“lipsum_aspose.pdf”, new PdfSaveOptions());

Tested with Aspose.Cells version 8.6.0 from nuget.
.NET Framework version is 4.5.1
2

Hi,


Thanks for providing us sample files.

After an initial test, I observed the issue as you mentioned by using your template file to convert to PDF file format. I found text is cut from right side when converting Excel file to PDF file format. I have logged a ticket with an id “CELLSNET-43963” for your issue. We will look into it soon.

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

Thank you.
3

Hi,


We have evaluated your issue further.
The width of column A in sheet[“Sheet1”] is too wide that it is larger than even page width. You’ll find this in MS Excel generated PDF, some text also lost at the top and bottom. You can reduce column width or enlarge page width (set larger paper size).

You can also fit width to one page by the following code:
e.g
Sample code:

Workbook wb = new Workbook(srcFile);
PageSetup pageSetup = wb.Worksheets[“Sheet1”].PageSetup;
pageSetup.FitToPagesTall = 0;
pageSetup.FitToPagesWide = 1;
wb.Save(outFile.pdf);

Hope, this helps a bit.

Thank you.