Reference Issue While Exporting as PDF

[HThagunna]

Hello,

We are having reference issue with the attached xlsx file while exporting it as PDF(With 2 sheets, name not starting with _).

However, while exporting it as xlsx and opening it in EXCEL 12+ we are not being able to see the reference issues in these two sheets. But, as we export it as PDF there is issue.

Attached:

1. Original spreadsheet that we are using with mappings.

2. Exported it as PDF.

[codewarior]

Hi Thagunna,

Thanks for contacting support.

As per above problem description, the issue appears to be related to Aspose.Cells for .NET, so I am moving this thread to respective forum and my fellow workers from respective team will further look into this matter and will reply accordingly. We are sorry for this inconvenience.

[shakeel.faiz]

Hi,

Thanks for your posting and using Aspose.Cells.

Please call Workbook.calculateFormula() before saving to pdf format and it should fix your issue. I have attached the output pdf for your reference.

We have tested this issue with your excel file using the following code with the latest version i.e. Aspose.Cells for Java v17.02.3.

Java

//Create workbook

Workbook wb = new Workbook(dirPath + “Health+Plan+Snapshot+EA+v2+(1).xlsx”);

//Perform fomula calculation

wb.calculateFormula();

//Set pdf save options, render entire worksheet on single page

PdfSaveOptions opts = new PdfSaveOptions();

opts.setOnePagePerSheet(true);

//Save the workbook

wb.save(dirPath + “output.pdf”, opts);