How to get AutoFilter Custom to work?

Aspose.Cells Product Family
1

I am doing

ws.AutoFilter.Range = "A5:W217";

ws.AutoFilter.Custom(1, FilterOperatorType.NotEqual, false);

Filter appears in excel document, but filter operator not applied.

Have also tried

ws.AutoFilter.Custom(1, FilterOperatorType.NotEqual, "FALSE");

ws.AutoFilter.Custom(1, FilterOperatorType.NotEqual, 36);

ws.AutoFilter.Custom(1, FilterOperatorType.NotEqual, "36");

2

Hi,

Thanks for using Aspose.Cells for Java.

Please create a filter manually using Ms-Excel and post your excel file.

We will look into it and help you with sample code asap.

3

This is exactly my issue too.


I use the code below:
//set autofilter
wsheet.AutoFilter.SetRange(9, 0, myTable.Columns.Count - 1);
wsheet.AutoFilter.Custom(
myTable .Columns.Count - 1, FilterOperatorType.NotEqual, “0”);
wsheet.AutoFilter.Refresh();

All I want to do is hide rows with 0 in that column.
I can see that the excel that I generate has the filter condition (under custom). But the filter is not applied.
I thought calling “Refresh()” actually applied the filter.

My version of Aspose is: aspose dll v 5.1.3.0
4

Hi,

Thanks for using Aspose.Cells for .NET.

Please download and use the latest version:
Aspose.Cells
for .NET v7.3.1.2
It should fix your issue.

If your problem still occurs, then please provide us your runnable sample code/project replicating this issue.

Please provide us any source (xls/xlsx) file you are using.

Please also provide us your actual and expected output (xls/xlsx) files.

We will soon look into your issue and help you asap

5

ok. i will check this out next week and let you know. I cant really test before then.

6

Hi,

Thanks for using Aspose.Cells for .NET.

Once, you test it, please share your feedback. Hopefully, you will not face any issue using the latest version.

Let us know if you still encounter this issue, we will be glad to look into your issue and fix it.