Hi,
I noticed that very often these properties (specified below) throw System.NullReferenceException durring accessing to them:
ColumnFields (Values)
Item
DataFields
InsertBlankRow
ShowInOutlineForm
ShowSubtotalAtTop
I’ve attached sample documents and demo project, that shows what value was returned by methods.
Best regards,
Alex Shloma
Hi,
I am afraid, we do not support to get properties for a pivot table which is linked to external data source at the moment. This issue is linked to your issue mentioned in your other thread. We already logged a ticket for it with an id: CELLSNET-40034.
We will look into it later.
Hi,
But I get such exceptions for all pivot tables, not only for who is linked to external data source.
Thank you,
Alex Shloma
Hi,
I tested your project with Aspose.Cells for .NET v7.0.2.2: please try it: v7.0.2.2.
It works fine for those pivot table’s properties (in “PivotDataNormalize.xlsx”) except for “ InsertBlankRow” and a few Items. We may look into the missing ones.
Thank you.