Filter, Sort, Group, and Search
Just like Microsoft Excel, DevExpress Spreadsheet API includes an AutoFilter - designed to filter data against column values and to display only the rows that meet specific criteria.
As you would expect, our Spreadsheet API supports grouping (outlines) and sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, dates, and time.
And of course, you can search within a worksheet, specify whether the operation should be case-sensitive, and search using wildcard characters.