Missing data with pdf output

Aspose.Cells Product Family
1

Dear support,

I’ve encountered an issue while I was trying to save the attached template to pdf.
As you will see in the second page the grid is almost empty.
This doesn’t happen if I save my template from MS Excel to pdf.

Here’s the code I’ve used:

Workbook Wb = new Workbook(txtSource.Text);

PdfSaveOptions SaveOpt = new PdfSaveOptions();

Wb.Save(txtOut.Text, SaveOpt);

Thanks.

2

Hi,

Thanks for your posting and using Aspose.Cells.

Please call Workbook.CalculateFormula() before saving your Excel file into PDF. Please see the following sample code. I have also attached the output PDF generated by the code for your reference.

I tested this code with the latest version: Aspose.Cells
for .NET v8.3.0.2.

C#


string filePath = @“D:\Downloads\Test.xlsx”;


Workbook Wb = new Workbook(filePath);


Wb.CalculateFormula();


PdfSaveOptions SaveOpt = new PdfSaveOptions();


Wb.Save(filePath + “.out1.pdf”, SaveOpt);