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

Free Support Forum - aspose.com

Pivot Percentage From Previous breaks after pivot.CalculateData()


file "Save2PivotPercentageFromPrevious.xlsx" shows incorrect percentages after CalculateData()

namespace ConsoleApplication1
class Program
static void Main(string[] args)
//Instantiate the License class
Aspose.Cells.License license = new Aspose.Cells.License();

//Pass only the name of the license file embedded in the assembly

Workbook workbook = new Aspose.Cells.Workbook(@"../../OriginalPivotPercentageFromPrevious.xlsx");


string file = @"../../Save1PivotPercentageFromPrevious.xlsx";
workbook.Save(file, Aspose.Cells.SaveFormat.Auto);

workbook.Worksheets["Sheet2"].PivotTables[0].CalculateData(); // this call has incorrect percentages

file = @"../../Save2PivotPercentageFromPrevious.xlsx";
workbook.Save(file, Aspose.Cells.SaveFormat.Auto);

Hi Ras,

Thank you for providing your sample source code and template file.

We are able to observe the problem as stated in your post, that is; after calling the PivotTable.CalculateData() method, previously calculated correct Pivot Percentage values are calculated incorrectly in the resultant spreadsheet. I have logged this issue in our bug tracking system under ticket Id CELLSNET-42065, for immediate investigate. We will look into this matter very soon, and we will keep you posted with updates.

We are sorry for your inconvenience.


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.


Please try our latest version/fix: Aspose.Cells for .NET v20.1.11 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.1.11 For .Net2_AuthenticodeSigned.Zip (5.0 MB)
Aspose.Cells20.1.11 For .Net4.0.Zip (5.0 MB)
Aspose.Cells20.1.11 For .NetStandard20.Zip (4.1 MB)

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