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

Free Support Forum - aspose.com

Problems refreshing Pivot

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

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.

Hi,


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

Thank you.

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.