The Data Menu

The Data menu is

Figure 4-20 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.

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.
Shuffle... — The Shuffle... menu item opens a sub-menu that allows various forms of data to be created.
Fill — The Fill menu item opens a dialog that allows users to shuffle a selection. Shuffling means to rearrange the cells in the selection into a random order. The dialog allows users to shuffle the data within a column, within a row, or within an area.
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.12 ― 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.
Consolidate... — The Consolidate... menu item opens a dialog box through which a user can create derived information based on data in other worksheets.
Table... —
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.

2 Data Modifications or Import.

These entries allow user to convert data already in a worksheet or to 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.
Import Data — The Import Data menu item provides the following sub-menu:

Figure 4-21 The Import Data submenu.

The items in this submenu allow the user to import data from various non-spreadsheet formats. To open files in a spreadsheet format, use the Open menu described in Section 4.2.2 ― The File Menu. See Section 14.2 ― File Formats for details. These submenu items create a new window containing the selected file. A more extensive discussion is presented in Section 14.3 ― Opening Files.
Export Data — The Export Data menu item provides the following sub-menu:

Figure 4-22 The Export Data submenu.

The items in this submenu allows users to export the current file or sheet to a non-spreadsheet format. The Repeat Export menu item repeats the last export in the current session or, if the file was recently imported, exports the file to the original source. To save data from Gnumeric in a spreadsheet format, use the Save As... menu described in Section 4.2.2 ― The File Menu. For an explanation of the file formats which Gnumeric supports see Section 14.5 ― Saving Files.