Pivot Table Show Value as Running Total in

Aspose.Cells Product Family
1

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/
2

@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
3

@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.

4

@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.

5

@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.

6

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