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

Free Support Forum - aspose.com

Pivot Table Show Value as Running Total in

Pivot Running Total.zip (8.5 KB)

  1. Open the attached excel file
  2. Note the values in the pivot table
  3. Call Workbook.Worksheets(0).PivotTables(0).CalculateData()
  4. Note the the values in the pivot table have changed from show values as running total/

@philipstone,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46444 - Pivot table value change after calling PivotTable.CalculateData

@philipstone,

We evaluated your issue thoroughly. I am afraid, we cannot support “Show values as” option for DataField now. We will support it later but we have no plan to support it in near future.

@philipstone,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@philipstone,
Please try our latest version/fix: Aspose.Cells for .NET v19.11.7:
Aspose.Cells19.11.7 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells19.11.7 For .Net4.0.Zip (5.0 MB)
Aspose.Cells19.11.7 For .NetStandard20.Zip (4.1 MB)

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-46444) have been fixed in Aspose.Cells for .NET v19.12. This message was posted using Bugs notification tool by Amjad_Sahi