The Data Menu

The Data menu is

Figure 4-9 The Data menu.

The menu choices are grouped into the following groups:

1 Data Field tools.

These menu items allow the user to re-organize data fields.

Sort... — The Sort... menu item opens a dialog which allows users to sort a selection according to defined criteria. By default Gnumeric sorts the rows in a selected area depending on the contents of the cells in a particular column of each row. The sort criteria can be extended to calculate on the basis of the cells in several columns. Gnumeric can sort a selection using any number of rules. Rules can be added using the Add button. Rules with no column entered will be ignored or the user can remove these rules with the Remove button.

For each rule, the dialog has an entry box in which the column to be sorted must be entered. The dropdown box (the little down pointing arrow) will show a list of appropriate columns. The user can determine a sort order for the selection. The Advanced button allows the user to further characterize the sort criteria..

If the first row of the selection is a header, Gnumeric can be told not to shuffle this row during the sort. Gnumeric can also sort columns based on the contents of cells in specified rows, instead of shuffling rows on the basis of columns, if the user toggles the Sort to act right-left instead of top-down.
Filter — The Filter menu item opens a sub-menu with three entries: Add Auto Filter, Show All, and Advanced Filter entry. Filters are explained in Section 5.11 ― Filtering Data.
Validate... — The Validate... menu item opens the cell format dialog to the validation tab. Validation is a means of constraining the contents of a cell either to have a certain value or to fall within a certain range.

2 Miscellaneous Entries.

These entries allow user to manipulate cell contents, alter the appearance of the worksheet or import external data directly into a worksheet.

Text to Columns... — The Text to Columns... menu item opens a dialog box through which a user can create derived information based on data in other worksheets.
Consolidate... — The Consolidate... menu item opens a dialog box through which a user can create derived information based on data in other worksheets.
Group and Outline — The Group and Outline menu item provides a sub-menu through which users can group rows or columns into units which can be collapsed to be hidden from view. These entries also allow users to alter the display of the grouping handles on the borders of the worksheet.
Get External Data — The Get External Data menu item provides a sub-menu which currently only allow the import of text data from an external source.