PivotTable calculation issue: cell value is truncated

Aspose.Cells Product Family
1

We experience calc issue in pivot tables, please see the attached file you can use to reproduce the issue:

var workbook = new Workbook("AsposeIssues//pivot_calc_trunc.xlsx");

var worksheet = workbook.Worksheets["WeeklyRep"];

var pivotTable = worksheet.PivotTables.First();

workbook.CalculateFormula();

pivotTable.RefreshData();

pivotTable.CalculateData();

Assert.Equal(32116000000.0, worksheet.Cells["D6"].DoubleValue); // but gives 2116000000.0

The truncated value 2116000000 shows up in HTML and PDF as well. When the filed is open in Excel, it shows 32116000000 in D6.

2

Hi Dmitry,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your sample code with your source Excel file using the latest version: and found the value of cell D6 is truncated.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43354 - PivotTable calculation issue: cell value is truncated

3

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.3.2.3 and let us know your feedback.

4

Yes, I can confirm that v8.3.2.4 doesn’t have this issue. Thanks

5

Hi,

Thanks for your feedback and using Aspose.Cells.

It is
good to know that your issue is resolved with the latest fix. Let us
know if you encounter any other issue, we will be glad to look into it
and help you further.

6

The issues you have found earlier (filed as CELLSNET-43354) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.