|
Sorting and filtering do not change or reorder the actual data in the table, but only its visible presentation. |
Sorting Rows
You can sort the rows of a Data Table being edited or viewed. To enable sorting, click the column header. Clicking a header already used for sorting will reverse the sorting order.
Filtering Rows
Another convenient feature is data filtering. To enable filtering, enter some text in filter text field located in Data Table Editor toolbar (and indicated by a looking glass icon). Table contents will be filtered to show only rows matching to the filter.
Context menu of the filter bar contains the following operations:
Column Selection |
Allows to perform searching in all columns or selected columns only. |
Case Sensitive |
Enables case sensitive searching. |
Case Insensitive |
Disables case sensitive searching. |
Use Wild Cards |
Enables/disables wildcard search mode. Wild cards may include * or ? characters that match any characters or any character, respectively. |
Use Regular Expressions |
Enables/disables regular expression search mode. |
Match From Start |
Filter text must appear in the beginning of cell text. |
Match Exactly |
Filter text must exactly match cell text. |
Match Anywhere |
Filter text may appear anywhere in the cell text. |