Replied 8 September 2017, 2:27 pm EST
OK, thanks. But if they are model row indexes, why are the values returned by GetIntersectedFilteredInRows different before and after a sort, which I would only expect to affect the view row indexes? For example, a first call to GetIntersectedFilteredInRows returns 2,4,5,3. Then I click the sort icon on a column, so that I see the same 4 rows in a slightly different order, call GetIntersectedFilteredInRows again, and get 2,3,1,0 this time.
Also, how is it that a call to GetIntersectedFilteredInRows immediately followed by a call to GetFilteredOutRowList returns sets of indexes, some of which are contained in both lists? In other words, how can a row be both filtered in and filtered out?
So far, the only way I've been able to programmatically determine which rows are filtered in or out is by using IsRowFilteredOut like this:
for (int i = 0; i < activeSheet.RowCount; i++)
which is also counterintuitive, since I would have thought 'i' was already indexing through view rows rather than model rows. Perhaps you can help clear up my confusion.