Problems refreshing Pivot

Aspose.Cells Product Family
1

Hi,

I am still having problems with pivot refresh. Aspose is not refreshing correctly.

If you run the code below and the file that I am providing you will see that after refreshing the pivot with aspose.cells the output takes all columns. After manually hitting refresh it works.

I am using the latest aspose.cell release

version/fix v7.0.2.4.

Dim wb As Workbook

wb = New Workbook("p4.xls")

Dim pivotable As Pivot.PivotTable

pivotable = wb.Worksheets("AcctDataSheet").PivotTables(0)

Dim lastrow As Integer = wb.Worksheets("AcctDataSheet").Cells.EndCellInColumn(0).Row

Dim range As Range = wb.Worksheets("AcctDataSheet").Cells.CreateRange(0, 0, lastrow + 1, 8)

range.Name = "AccDataRange"

pivotable.RefreshData()

pivotable.CalculateData()

wb.Save("p4.xls")

I need help fixing this problem

Thanks

2
Hi,

I can find the issue as the user mentioned using his template file with sample code. The pivot table is not refreshed same as MS Excel. I have logged a ticket with an id: CELLSNET-40075. We will look into it soon.

Thank you.
3

Hi,


Please try the attached version v7.0.2.6, we have fixed your issue now.

Thank you.

4

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.