The Menu bar

The default location of the menu bar is the top of the application window. It provides a quick and organized access to some of the more common operations available.

File

This menu contains:

  • New — Create a new worksheet. This opens a new worksheet in a window.

  • Open — Open an existing worksheet. A new window is created with the file selected in it.

  • Import — FIXME

  • Save — Save the current worksheet. If the file has been named and saved before, this will silently save the file to the current filename. If it has not been saved before, this will prompt for a filename and path.

  • Save As — Save a file with a new name. Save a newly created file or save a file with a different name

  • Summary — Open the summary dialog. Displays a summary of the information about the current workbook.

  • Print Setup — Displays the print setup dialog, from which various options relating to printing can be configured. This is detailed in the section called Print Setup. in Chapter 7

  • Print — Print the current worksheet. This is detailed in the section called Printing to a Printer or a File. in Chapter 7

  • Print Preview — Displays a print preview of the current worksheet. This is detailed in the section called Print Preview. in Chapter 7

  • Close — Close the current worksheet.

  • Exit — Close the open worksheets and quit Gnumeric

Edit

This menu contains:

  • Undo — Undoes the last action undertaken.

  • Redo — Reverses the previous undo operation, restoring the worksheet to its orginal state.

  • Cut — Remove the content in the currently selected cells and save it.

  • Copy — Make a copy of the current selection to be pasted later.

  • Paste — Paste whatever is in the cut buffer at the cursor.

  • Paste Special — Paste from the cut buffer, but with more options as to what to paste. Useful for pasting just format, or just values, etc.

  • Clear -> — This sub menu contains:

    • All —Clear every cell.

    • Formats —Clear the format from selected cells.

    • Comments —FIXME

    • Content —FIXME

  • Delete — Deletes the currently selected region

  • Delete Sheet — Select every cell in the worksheet.

  • Select All — Select every cell in the worksheet.

  • Goto Cell... — FIXME

  • Recalculate — FIXME

View

This menu contains:

  • Zoom — Displays the zoom dialog, which allows the zoom level for the workbook to be changed.

Insert

This menu contains:

  • Sheet —Insert a Sheet in the current workbook.

  • Rows —Insert a Row of cells.

  • Columns —Insert a Column of cells.

  • Cells —Insert new cells.

  • Define Name —FIXME

  • Add / Modify comment —FIXME

  • Special -> —This sub menu contains:

    • Current Date —Inserts the current date into the currently selected cell.

    • Current Time —Inserts the current time into the currently selected cell.

Format

This menu contains:

  • Cells —Open the cell format dialog. Used to change formatting, color, etc.

  • Column-> — This submenu contains:

    • Auto Fit Selection —Automatically chooses the optimal size for the column which shows all the text entered.

    • Width —Allows the user to adjust the size of the column.

    • Hide —Hides the selected columns so that they are not visible.

    • Unhide —Makes any columns selected that have being hidden visible again.

    • Standard Width —Resizes the columns back to the default width of 6.63.

  • Row-> — This sub menu contains:

    • Auto Fit Selection —Automatically chooses the optimal size for the row which shows all the text entered.

    • Height —Allows the user to adjust the size of the row.

    • Hide —Hides the selected rows so that they are not visible.

    • Unhide —Makes any rows selected that have being hidden visible again.

    • Standard Height —Resizes the rows back to the default height of 11.61.

  • Sheet-> — This sub menu contains:

    • Change Name

    • Display Formulas

    • Hide Zeros

    • Hide Gridlines

    • Hide Column Header

    • Hide Row Header

  • Workbook —Allows you to configure whether tabs and row and column headers will be shown.

Tools

This menu contains:

  • Plug-ins —Displays a list of the plugins currently installed.

  • Auto Correct —Allows the user to configure various auto-correcting functions used when entering data.

  • AutoSave —Allows the user to automatically save after a specified number of minutes

  • Goal Seek —FIXME

  • Solver —Brings up the Solver Dialog, which can be used to solve linear equations. This is detailed in Chapter 8

  • Data Analysis —Allows various forms of data analysis to be used on a set of data. This is detailed in Chapter 9

Data

This menu contains:

  • Sort —Sorts a selection of cells into ascending or descending order, based on the first column selected.

  • Filter —FIXME

Help

This menu contains:

  • Gnumeric Manual —Display this manual.

  • Gnumeric Function Reference —View the Gnumeric function reference, a list and description of the functions available in Gnumeric.

  • About —hows basic information about Gnumeric, such as the authors' names and the application version number.