How to detect if a range is INCLUDED or EXCLUDED by an autofilter option?

[Gian]

We need to know if a range is visible or hidden (excluded) in an autofilter's range: is it possible?

[Thirumurugan Loganathan]

Hi Gian, 

 

You can detect visible or hidden row of the AutoFilter’s ranges by using IsRowVisible property of the Worksheet. Please refer the below code sample for your reference. 

 

this.spreadsheetControl.WorkbookLoaded += SpreadsheetControl_WorkbookLoaded; 

 

private void SpreadsheetControl_WorkbookLoaded(object sender, WorkbookLoadedEventArgs args) 

{ 

            if (spreadsheetControl.ActiveSheet.AutoFilters.Count > 0) 

            { 

                        var firstRow = spreadsheetControl.ActiveSheet.AutoFilters.FilterRange.Row; 

                        var LastRow = spreadsheetControl.ActiveSheet.AutoFilters.FilterRange.LastRow; 

                        for (int row = firstRow; row <= LastRow; row++) 

                        { 

                                    bool isRowVisible = spreadsheetControl.ActiveSheet.IsRowVisible(row); 

                        } 

            } 

} 

 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/133046/ze/SpreadsheetDemo-1658180679  

 

Regards, 

Thirumurugan