Strange behavior in pivot table when calculating

Aspose.Cells Product Family
1

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.

2

@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

3

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

4

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

5

@akquinet,

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

6

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

7

Thank you very much, it works.

8

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