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

Free Support Forum - aspose.com

PivotTable. Filtering in Excel 2007 and later versions. Incorrect and not full data


I have several questions (for better understanding please see attached files):

1. Are there any difference between these options? If they are different, could you create samples for situations When they are used?

2. These methods is not work with documents in *.xls format. I converted document from previous post to *.xls and Aspose.Cells found nothing. The macro in converted document returns the same information as the macro in original document.

3. Some properties return incorrect data. I used document from previous post. The result from macro you can see at attached image (macroFilter2.png).
EvaluationOrder = 2
Value1 = “1”
EvaluationOrder = -1
Value1 = “”

‘Value2’ has the same problem as ‘Value1’. For example, ‘ValueNotBetween’ filter.

PivotFieldCollection pfc = pt.RowFields;
for (int i = 0; i < pfc.Count; i++)
PivotField pf = pfc[i];
foreach (PivotFilter pfl in pf.GetPivotFilters())
printLine(“Name”, pfl.Name, SPACE4); // my inner printing method
printLine(“FilterType”, Enum.GetName(typeof(PivotFilterType), pfl.FilterType), SPACE5);
printLine(“EvaluationOrder”, pfl.EvaluationOrder.ToString(), SPACE5);
printLine(“FieldIndex”, pfl.FieldIndex.ToString(), SPACE5);
printLine(“MeasureFldIndex”, pfl.MeasureFldIndex.ToString(), SPACE5);
printLine(“MemberPropertyFieldIndex”, pfl.MemberPropertyFieldIndex.ToString(), SPACE5);
printLine(“Value1”, pfl.Value1, SPACE5);
printLine(“Value2”, pfl.Value2, SPACE5);
printLine(“Filters”, " ============== ERROR ============== ", SPACE4);

4. Some filter types have no full information about filter. For example, ‘Top 10…’ filter returns ‘Count’ without ‘Top’ or ‘Bottom’. Is it exist any way to read these options?

5. Missing properties.
Excel Developer Reference
PivotFilter Object Members
Active - Returns whether the specified PivotFilter is active. Read-only Boolean.
Description - Provides an optional description for the PivotFilter object. Read-only String.

I use Aspose.Cell v

Thank you,
Alex Shloma


Thanks for considering Aspose.Cells for .NET and posting your questions.

I have logged your questions in our database. Development team will review them and once we will get any update, we will let you know.

This issue has been logged as CELLSNET-40207.

Please try our latest version/fix: Aspose.Cells for .NET v21.6.3 (attached)
Aspose.Cells21.6.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.3 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.