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

licenses · October 27, 2011, 4:19am

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

amjad.sahi · October 27, 2011, 4:52am

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.

licenses · October 27, 2011, 5:20am

Hi,

But I get such exceptions for all pivot tables, not only for who is linked to external data source.

Thank you,
Alex Shloma

amjad.sahi · October 27, 2011, 1:43pm

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.