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

Free Support Forum - aspose.com

Strange behavior in pivot table when calculating

Hi guys,
I have a strange behavior in the pivot table when it is recalculated with “CalculateData”.
When I have a column formatted as currency and then I use the option “show format for empty cells” MS Excel calculates “0,00 €”.
If I do this with Aspose.Cells in the newest version (21.6.0) i always get only a “0” as text at this place.
Here are a few screenshots and a example app.

Screenshot_01.png (50.4 KB)
Screenshot_02.png (53.0 KB)
Screenshot_03.png (36.8 KB)

PivotTableZero.zip (103.7 KB)

Thanks for your support.

@akquinet,
We have observed this issue and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNETCORE-122 - Pivot Table column formatted with custom currency shows values as text

Thanks for your support.
As soon as you provide me with a new version I will test it.

@akquinet,
Sure, we will let you know once the issue is resolved and the fix is ready for sharing.

@akquinet,

Your issue will be fixed in the next week and we will provide the fixed version before then end of next week.

@akquinet,
Please try our latest version/fix: Aspose.Cells for .NET v21.7.1 (attached)
Aspose.Cells21.7.1 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.7.1 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.7.1 For .NetStandard20.Zip (5.6 MB)

Your issue should be fixed in it.
Let us know your feedback.

Thank you very much, it works.

@akquinet,

Good to know that your issue is resolved by the new fix. In the event of further queries or issue, feel free to write us back.