Excel to PDF data is cut in the output file using C#.NET

Aspose.Cells Product Family
1

Hi,

I used the 19.3.0 .net version of aspose.cells to convert a workbook to a PDF. The workbook we’re loading has the page setup properties to fit to a single page in landscape.

var workbookStream = new FileStream("TestFitToPage.xlsx", FileMode.Open);
var workbook = new Workbook(workbookStream);
var saveOptions = new PdfSaveOptions() {  };
workbook.Save(@"AsposeConversion.pdf", saveOptions);

If you compare the output to AsposeConversion.pdf and ExcelConversion.pdf, you can see that aspose is cutting off data in the last column and outputs less data than when you try to save the workbook as a pdf natively in excel. It looks like aspose is only taking into account the column width, but excel shows the overflowing data as long as there isn’t more data to the right of that cell.

TestFitToPage.zip (87.3 KB)

2

@dfactset,

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-46689 - Saving a workbook as PDF is different then excel’s native output
3

@dfactset,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46689”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@dfactset,

Please try our latest version/fix: Aspose.Cells for .NET v19.4.2 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.4.2 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.4.2 For .Net4.0.Zip (4.9 MB)

5

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