Can not retrieve manual filter from pivot table in the attached file

Aspose.Cells Product Family
1

Hi,

I am trying to get the filter information from the first column of the pivot table in the "Sheet1" of attached file.

However, I can't find any filter either in pivottable.PivotFilters or pivotField.GetPivotFilters(). Is there a way I could get the filter info from the attached file?

In addition, if I click the sort descending in the filter, is there a way to get this information as well?

Thanks and regards

Bill

Solvexia

2

Hi,


Thanks for the sample file.

I looks like a new feature/improvement that you are demanding for. I have logged a ticket with an id: CELLSNET-40328. We will look into it soon.

Thank you.
3

Hi,

The pivot field named “Classification1” hides the item named “BB”,and there’s no filter such as “value filters” in the pivot field.

You could traverse the pivot fields and find which item is being hidden and in addition, you can use IsAscendSort property of the pivot field.

4

Thanks Shakeel!

I understand the IsAscendSort part. Could you provide me a small sample code about traverse the pivot fields?

Another question is: is the output going to be the same as what you see in the attached workbook?

Regards

Bill

5

Hi,

I have forwarded your question to our development team, we will help you asap.

6

Hi,
.
We have fixed this issue. Please download: Aspose.Cells for .NET v7.1.0.5

We will provide you a sample code asap.

7

Hi,


Here is the sample code:

sample code:
for (int i = 0; i < field.ItemCount; i++)
{
if (field.IsHiddenItem(i))
{
continue;
}
}
8

Hi,

Just let you guys know this is just the fix we need. Many thanks!

Regards

Bill