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.
PivotTableZero.zip (103.7 KB)
Thanks for your support.