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

Free Support Forum - aspose.com

PivotTable. Incorrect 'Allow multiple filters per field' 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 states for ‘Allow multiple filters per field’.

IsMultipleFieldFilters = false
IsMultipleFieldFilters = true

Workbook wb = new Workbook(fName);
foreach(Worksheet ws in wb.Worksheets)
foreach(PivotTable pt in ws.PivotTables)
try { pt.RefreshData(); }
catch { }
try { pt.CalculateData(); }
catch { }
try { pt.CalculateRange(); }
catch { }

printLine(“IsMultipleFieldFilters”, pt.IsMultipleFieldFilters.ToString(), SPACE2); // my inner printing method

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

Thank you,
Alex Shloma


Thanks for your posting and using Aspose.Cells for .NET.

We at Aspose wish you a great 2013 year. Please keep us in your good wishes as well.

We were able to replicate this issue using the latest version:

We have logged this issue in our database. We will look into this issue and fix it. Once the issue is fixed or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41330.


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

We have fixed your issue now.

Let us know your feedback.

Thank you.

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

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