Hi,
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 http://msdn.microsoft.com/en-us/library/dd910980%28v=office.12%29.aspx
.
Could you please fix the compatibility with last MS Office formats or show me another enumeration, if it already exists?
Thank you,
Alex Shloma
Hi,
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.
Thank you.
Thank you!
Hi,
Unfortunately I have the same result.
I created simple Excel file with pivot table (file is attached).
Data fields: Excel: v7.0.3.1
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
Code snippet:
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
}
Alex Shloma
Hi,
We have logged your comment in our database. We will look into it and fix it asap.
Thank you!
With new version all works fine!
Best regards,
Alex Shloma
The issues you have found earlier (filed as CELLSNET-40095) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.