Free Support Forum - aspose.com

A lot of properties throw the exceptions (System.NullReferenceException)

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.