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

Free Support Forum - aspose.com

How to know whether the rows is filtered?

how to know whether the rows is filtered?


Well, I think you may use RowFilterSettings.EnableAutoFilter boolean attribute to check whether it is true or false.

bool filterCheck = GridWeb1.WebWorksheets[0].RowFilter.EnableAutoFilter;

Thank you

the Webworksheet contains 10 rows, I use [rowFilter.FilterRows();] to filter,

which method I can know the first row is filtered,or the second row is not filtered?


Thanks for providing further details.

We will look into it and get back to you soon.

Thank you.


After analyzing the feature, we can provide filtered row(s) indexes list as return value of FilterRows() method. Will it suit your need?

Thank you.


I need this functionality (ie. filterRows to return list of indexes of filtered rows). Is it available?



We will get back to you soon.

Thanks for being patient!


Please try the attached version Aspose.Grid.Web v2.0.1.2011, it supports to return filtered rows indexes via invoking FilterRows method which can return ArrayList object now.


grdWeb.WebWorksheets[0].RowFilter.Criteria = "OR(CELL1 = 180, CELL3 = 90)";

ArrayList list = grdWeb.WebWorksheets[0].RowFilter.FilterRows();

Thank you.

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.