Aspose cells and setting filter on pagefield

Aspose.Cells Product Family
1

Dear sir/madam,

For my company I am trying with your trial version of Aspose Cells to set the filter on a pagefield within a pivot table. I discover that this is not possible. I would like to set a filter and by that way see how the graph changes that is based on the pivot table.

I am curious if you have a solution for this.

Best regards,
Nico Horsmans

2

I am working with Excel 2007 and I am trying to do so in C# .NET.

Regards,
Nico Horsmans

3

Hi,

Well, I think you may try to use:
PivotField.HideItem(int index, bool isHidden)/PivotField.HideItem(string itemValue, bool isHidden)

method several times (accordingly) to hide all the items except for your desired item
for which you need to select in the drop down.

Thank you