Sorting and AutoFilter
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.
<dx:BootstrapSpreadsheet runat="server" ActiveTabIndex="2" ShowConfirmOnLosingChanges="false">
</dx:BootstrapSpreadsheet>