# Toolbars

The toolbars contain buttons and other elements which can be used to perform quickly some the more common operations. Each button has an icon intended to provide a mnemonic reminder of the operation performed by the button. The toolbar elements are intended to provide fast access to the commonly used tools. Almost all of these functions are also available through the menu system. The specific actions required to use each button vary.

&gnum; has four toolbars, the standard toolbar, the format toolbar, the long format toolbar, and the object toolbar. The three toolbars are shown in .

## The Four Gnumeric Toolbars

These toolbars will be discussed separately in the subsequent sections of this manual. User interaction with each toolbar happens in essentially the same way. Similarly, the toolbars can be configured in the same way. The next section explains the standard behavior of &gnum; toolbars.

The long format toolbar contains all of the buttons of the format toolbar plus a few extra buttons, but in a differnet order. Users will usually choose only one of these toolbars to be displayed.

## General Toolbar Behavior

The toolbar context menu described in can be used to determine where each toolbar (above the sheets, to the left of the sheets, or to the right of ths sheets) is being displayed. The Toolbars submenu of the View menu (see ) can be used to determine which toolbars are visible.

If the &gnum; window is too small to fit all of the toolbar buttons, gnumeric displays an arrow to indicate that there are more options. If the user clicks on this arrow, a window will open with the remaining buttons as shown in .

### The Toolbar Extension Menu

Certain toolbar options, such as the zoom box, are combinations of a button or text entry area and a downward pointing arrow. If the user clicks on the arrow, a list of available options appears.

## The Standard Toolbar

The standard toolbar is shown in .

### The Standard Toolbar

The Standard Toolbar gives the user access to file operations, printing, movement of data blocks, the undo system, and to some of the powerful tools like the function creator and the graphing system.

An image of the standard toolbar's "New File" button. New File.

  Create a new file.

An image of the standard toolbar's "Open File" button. Open

  Open an existing file.

An image of the standard toolbar's "Save File" button. Save

  Save the current worksheet to disk.

An image of the standard toolbar's "Print" button. Print

  Print the current worksheet or workbook to a file or a printer.

An image of the standard toolbar's "Print Preview" button. Print Preview

  Display a print preview of the current worksheet.

An image of the standard toolbar's "Cut" button. Cut

  Copy the cells in the current selection to the clipboard buffer and mark them to be deleted from the current position. The cells will only be removed if they are pasted into a new position.

An image of the standard toolbar's "Copy" button. Copy

  Copy the cells in the current selection to the clipboard buffer.

An image of the standard toolbar's "Paste" button. Paste

  Paste the contents of the clipboard buffer into the active cell.

An image of the standard toolbar's "Undo" button. Undo

  Undoes the last operation undertaken.

An image of the standard toolbar's "Redo" button. Redo

  This is the reverse of the undo operation, restoring its original state.

An image of the standard toolbar's "Insert Hyperlink" button. Insert a hyperlink

  This button opens a dialog to allow the user to define a hyperlink either internally within the spreadsheet or to an external resource such as a web page.

An image of the standard toolbar's "Sum" button. Sum into the current cell

  Starts a simple sum formula in the selected cell with &gnum; simply waiting for a selection to be made to complete the sum. The user selects the destination cell, pushes this button, enters the range to be summed and pushes the confirm button (green arrow) in the data entry area or types the Return key.

An image of the standard toolbar's "Function" button. The function druid

  This button will start a formula in the current cell using the function druid.

An image of the standard toolbar's "Sort A to Z" button. Sort Ascending

  Sorts the selected region in ascending order based on the first column selected.

An image of the standard toolbar's "Sort Z to A" button. Sort Descending

  Sorts the selected region in descending order based on the first column selected.

An image of the standard toolbar's "Graph" button. Graph

  This button calls the graph druid to create a graph.

An image of the standard toolbar's "Zoom" box. Zoom

  The zoom button allows the users to trade-off the extent of the worksheet which is visible against the size of the visible text and cells.

## The Format Toolbar

The Format Toolbar

### The Format Toolbar

An image of the format toolbar's "Font" selection box. Font Chooser.

  The user can change the font of a selection either by typing the name of a new font in the text area of this box or by clicking on the little arrow to the right of the text area. This will cause a menu to appear from which a font can be chosen.

An image of the format toolbar's "Font Size" selection box. Font size

  The user can change the font size of a selection by typing the number of a different font size or by clicking on the little arrow to the right of the entry box and selecting the preferred size.

An image of the format toolbar's "Bold" button. Bold

  Change the style of the current cell or the currently selected text to be bold, or un bold it if it is already bold.

An image of the format toolbar's "Italic" button. Italic

  Change the style of the current cell or the currently selected text to be italicized.

An image of the format toolbar's "Underline" button. Underline

  Change the style of the current cell or the currently selected text to be underlined.

An image of the format toolbar's "Left Justify" button. Left justify..

  Justify the contents of the cell to the left of the cell.

An image of the format toolbar's "Center" button. Center

  Center the content of the cells.

An image of the format toolbar's "Right Justify" button. Right Justify

  Justify the content of the cells to the right side of the cells

An image of the format toolbar's "Center across Selection" button. Center across the selection

  Center the content of the cells on the selected cells.

An image of the format toolbar's "Merge Cells" button. Merge Cells

  Merge the selected cells into a single cell.

An image of the format toolbar's "Split Merged Cells" button. Split Merged Cells

  Split previously merged cells into separate cells.

An image of the format toolbar's "Money" button. Money

  Sets the format of the selected cells to be monetary.

An image of the format toolbar's "Percentage" button. Percentage

  Sets the format of the selected cells to be a percentage.

An image of the format toolbar's "Thousands Separator" button. Thousands separator

  Sets the format of the selected cells to use thousands separator.

An image of the format toolbar's "Increase Precision" button. Increase the displayed precision.

  Increases the number of decimals shown in the currently selected cell.

An image of the format toolbar's "Decrease Precision" button. Decrease the displayed precision.

  Decreases the number of decimals in the currently selected cell.

An image of the format toolbar's "Decrease Indentation" button. Decrease the displayed indentation.

  This button decreases the indentation of selected elements.

An image of the format toolbar's "Increase Indentation" button. Increase the displayed indentation.

  This button increases the indentation of selected elements.

An image of the format toolbar's "Borders" button and drop down palette. Change the display borders.

  This button and drop down menu can be used to set the borders of all the cells in the selection.

An image of the format toolbar's "Set background colour" button and drop down palette. Set the Background Colour.

  This button and drop down menu can be used to set the back ground colour.

An image of the format toolbar's "Set text colour" button and drop down palette. Set the Text Colour

  This can be used to change the colour of the text.

## The Long Format Toolbar

The Long Format Toolbar

### The Long Format Toolbar

The Long Format Toolbar contains all buttons that the Format Toolbar (described in ) contains, except in a differnet order.

In addition, the Long Format Toolbar also contains the following buttons:

An image of the long format toolbar's "Subscript" button. Subscript

  Change the style of the current cell or the currently selected text to be subscripted.

An image of the long format toolbar's "Superscript" button. Superscript

  Change the style of the current cell or the currently selected text to be superscripted.

## The Object Toolbar

### The Object Toolbar

The Object Toolbar.

An image of the object toolbar's "Create a rectangle object" button. Box

  Insert a rectangular box containing optionally some text into the worksheet.

An image of the object toolbar's "Insert an Ellipse" button. Ellipse

  Insert an ellipse or a circle into the worksheet.

An image of the object toolbar's "Insert a Frame" button. Insert a Frame.

  This button allows a user to insert a frame into a worksheet.

An image of the object toolbar's "Insert a Line" button. Line

  Draw a line on the worksheet.

An image of the object toolbar's "Insert an Arrow" button. Arrow

  Draw a line with an arrow head at one end.

An image of the object toolbar's "Insert a Checkbox" button. Insert a Checkbox.

  This button allows a user to insert a check box.

An image of the object toolbar's "Insert a Radio Button" button. Insert a radio button.

  This button allows a user to insert a radio button.

An image of the object toolbar's "Insert a Button" button. Insert a button.

  This button allows a user to insert a button.

An image of the object toolbar's "Insert a Scrollbar" button. Insert a Scrollbar.

  This button allows a user to insert a scrollbar.

An image of the object toolbar's "Insert a spinbutton box" button. Insert a Spinbutton Box.

  This button allows a user to insert a spinbutton box.

An image of the object toolbar's "Insert a Slider" button. Insert a Slider.

  This button allows a user to insert a slider.

An image of the object toolbar's "Insert a List" button. Insert a List.

  This button allows a user to insert a list.

An image of the object toolbar's "Insert a Combobox" button. Insert a Combo Box

  This allows a user to insert a Combo Box.