We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

IFERROR(IF formula values does not appear in pivot table in PDF


We found and issue with converting XLSX files to PDF where the xlsx file contains a formula column using an “=IFERROR(IF(…)…)” formula that has been add to a pivot table. When the xlsx file is refreshed and re-saved as a PDF file, the generated PDF file show no value in the pivot column.

I have attached a small project to demonstrate the issue. I have also attached an input file “input file with IFERROR Formula.xlsx” for you to use.

The input file has three pivot tables; (1) with an “IFERROR(IF(…),…)” formula, (2) same if formula as 1 but without the “IFERROR(…)” wrapper, and (3) with an “IFERROR(Column,”")" formula.

When you check the output PDF file you can see that only the first pivot table shows the empty column.


Thanks for your posting and using Aspose.Cells for .NET.

We were able to observe this issue using your sample project and source file. The first pivot table shows the empty column in the output pdf. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41971.


Thanks for your posting and using Aspose.Cells for .NET.

We have fixed the issue.

Please download and try this fix: Aspose.Cells for .NET v7.5.3.4 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-41971) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.