The enumeration for property ‘DataDisplayFormat’ has 9 values, but the last Excel version (2010) has 15 values (see attached image).
You can see enumeration for new items here
Could you please fix the compatibility with last MS Office formats or show me another enumeration, if it already exists?
pivotfield.DataDisplayFormat = PivotFieldDataDisplayFormat___________; The enumeration only provides 9 members or so. I have added a ticket for an enhancement with an id: CELLSNET-40095. We will look into it soon.
We have fixed this issue. Please download:
Aspose.Cells for .NET v18.104.22.168
Unfortunately I have the same result.
I created simple Excel file with pivot table (file is attached).
Data fields: Excel: v22.214.171.124
Jan (Count of Jan) % of Parent Row Total Normal
Feb (Count of Feb) % of Parent Column Total Normal
Mar (Count of Mar) % of Parent Total Normal
Apr (Sum of Apr) Difference From DifferenceFrom
PivotFieldCollection pfc = pt.DataFields;Thank you,
for (int i = 0; i < pfc.Count; i++)
PivotField pf = pfc[i];
printLine(“DataDisplayFormat”, Enum.GetName(typeof(PivotFieldDataDisplayFormat), pf.DataDisplayFormat), SPACE4); // my inner printing method
We have logged your comment in our database. We will look into it and fix it asap.
With new version all works fine!