Hi,
id=“Aspose.Cells” version=“7.7.1”
id=“Aspose.Pdf” version=“8.8.1”
Please advice, is this a bug? is this something I am doing wrong? is there a workaround?Thanks!
Hi,
id=“Aspose.Cells” version=“7.7.1”
id=“Aspose.Pdf” version=“8.8.1”
Please advice, is this a bug? is this something I am doing wrong? is there a workaround?Thanks!
Hi Joshua,
Thanks for your posting and using Aspose.Cells.
Please clear the print area of your worksheet which is set to A1:I15 before creating your pdf. We have cleared the print area and now the generated pdf has a complete pivot table.
We have tested it with the latest version: Aspose.Cells
for .NET v7.7.1.4
You can clear the print area using the following code. I have also attached the output pdf for your reference.
wb.Worksheets(“Settlement By Producer”).PageSetup.PrintArea = “”
However, the issue of date format inside the pivot table does exist in the output pdf file. We have logged this issue in our database for a fix. Once, this issue is fixed or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-42336.
I have also attached the screenshot highlighting this issue for a reference.
VB.NET
The issues you have found earlier (filed as CELLSNET-42336) have been fixed in this update.