We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PivotField. Incorrect 'Include new items in manual filter' state. (*.xlsb)


I created a simple document with Pivot Table in *.xlsx and *.xlsb format. It’s the same document converted from *.xlsx to *.xlsb by Excel, but Aspose.Cells returns different state for ‘IsIncludeNewItemsInFilter’ field in row, column and page fields.
ColumnField - ‘Region’, RowField - ‘Product’, PageField - ‘Jan’
IsIncludeNewItemsInFilter = true
IsIncludeNewItemsInFilter = false

PivotFieldCollection pfc = pt.RowFields; // the same for ‘ColumnFields’ and ‘PageFields’
for (int i = 0; i < pfc.Count; i++)
PivotField pf = pfc[i];
// my inner printing method
printLine(“IsIncludeNewItemsInFilter”, pf.IsIncludeNewItemsInFilter.ToString(), SPACE4);

I use Excel 2010 and Aspose.Cells v7.3.5.1.

Thank you,
Alex Shloma


Thanks for providing us the template files and sample code.

After an initial test and using your code with your template XLSB file, I have managed to reproduce the issue as you have pointed out. I have logged a ticket with an id “CELLSNET-41336” for your issue. We will look into your issue soon.

Thank you.

Please download and try our latest fix/version: Aspose.Cells for .NET v7.7.0.4

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

The issues you have found earlier (filed as CELLSNET-41336) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.