Pivot table output to pdf issue[Urgent]

Aspose.Cells Product Family
41

HI Amzad,


still i am getting issue with your suggested dll.
See attaached pdf and the screenshot.
If you look at the row of MISCELLANEOUS then in your output its not Bold which is correct but in my output its coming Bold which is the issue.
let me know if you need more information about it.

Below is the code which i have used.

Dim wb As New Aspose.Cells.Workbook(“C:\Reports70\temp\PIVOT_78_0.xlsx”)
Dim myWorkBook As Aspose.Cells.WorkbookDesigner
Try
Dim pivot As Aspose.Cells.Pivot.PivotTable
Dim pchart As Aspose.Cells.Charts.Chart
''refreshing pivot tables and charts from all worksheets
For Each ws As Aspose.Cells.Worksheet In myWorkBook.Workbook.Worksheets
For Each pivot In ws.PivotTables
pivot.PreserveFormatting = True
pivot.RefreshData()
pivot.CalculateData()
Next

For Each pchart In ws.Charts
pchart.RefreshPivotData()
Next
ws.AutoFitRows(True)
Next
Catch ex As Exception
End Try
wb.Save(“C:\Reports70\temp\PIVOT_78_0.pdf”)
42

Hi,


There is an error in your code. Please see the updated code here, it works fine. Please see the lines in bold.

Sample code:

Dim wb As New Aspose.Cells.Workbook(“e:\test2\PIVOT_78_0.xlsx”)
Dim myWorkBook As New Aspose.Cells.WorkbookDesigner()
myWorkBook.Workbook = wb

Try
''refreshing pivot tables and charts from all worksheets
For Each ws As Aspose.Cells.Worksheet In myWorkBook.Workbook.Worksheets
For Each pivot As Aspose.Cells.Pivot.PivotTable In ws.PivotTables
pivot.PreserveFormatting = True
pivot.RefreshData()
pivot.CalculateData()
Next pivot

For Each pchart As Aspose.Cells.Charts.Chart In ws.Charts
pchart.RefreshPivotData()
Next pchart
ws.AutoFitRows(True)
Next ws
Catch ex As Exception
End Try
wb.Save(“e:\test2\outPIVOT_78_0.pdf”)
43

Hi Amjad,


no this issue is still not resolved.see attached the excel which i converted into pdf. but still getting percentage with big values.
44

Hi,


Thanks for providing us your template file and output PDF file.

After an initial test, using my previous code, I found the issue as you mentioned with your template file, the percentage values in the PivotTable are wrong and not formatted correctly. I have logged a ticket with an id “CELLSNET-42145” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.


45

@rajsingh85007,
Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.