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 v184.108.40.206.