Pivot Percentage From Previous breaks after pivot.CalculateData()

Aspose.Cells Product Family
1

version 7.5.3.5

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
license.SetLicense("Aspose.Total.lic");

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

workbook.Worksheets["Sheet2"].PivotTables[0].RefreshData();

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);
}
}
}

2

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.

3

@scenictours,

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.

4

@scenictours,

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)

5

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