End-users can use the Excel inspired AutoFilter feature to filter data by columns and to easily display only rows that meet specific conditions. Filtering commands located on the Data tab in the Sort & Filter group can be used to activate filtering, reapply the filter or completely remove all filters in a worksheet.
Once filtering is activated, a drop-down arrow appears on the right side of each column header in the range. An end-user can click the arrow of the required column and select one of predefined filter types in the AutoFilter drop-down menu. The content of the AutoFilter menu depends on the type of data in the filtered column. Three filter types are available: Text Filters, Number Filters and Date Filters. In addition, the Filter by Values option, which allows you to select unique values from columns can be used.
To learn more about AutoFilter feature, refer to the Filtering help topic.
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
The source code files for this demo are installed (by default) in the following directory:
Open CS Solution
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\MVCxSpreadsheetDemos