How to know whether the rows is filtered?

Aspose.Cells Product Family
1

how to know whether the rows is filtered?

2

Hi,

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

3

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?

4

Hi,

Thanks for providing further details.

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

Thank you.

5

Hi,

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.

6

Hello,

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

regards

7

Hi,

We will get back to you soon.

Thanks for being patient!

8

Hi,

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.

e.g.

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

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

Thank you.

9

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.