# 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 three toolbars, the standard toolbar, the format toolbar and the object toolbar. The three toolbars are shown in .

## The Three 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.

## General Toolbar Behavior

In the same way that menus can be moved around, as was explained , toolbars can be moved around the &gnum; window by dragging the little tag on the leftmost portion of the toolbar.

If the &gnum; window is too small to fit all of the toolbar buttons, gnumeric may display a little right pointing black arrow to indicate that there are more options. If the user clicks on this arrow, a window will open with the remaining buttons.

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 "Insert Object" button. Insert Object

  This button will insert a component object into the current worksheet. Components are the way that the GNOME project has chosen to enable certain programs to use others within themselves. &gnum; is able to use the Guppi plotting program and the Dia diagramming program in this way.

An image of the standard toolbar's "Insert Component" button. Insert Shaped Component

  This button allows user to insert a component into &gnum; that is not a simple rectangle but may have an arbitrary shape. This functionality is currently not used but provided for future needs.

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

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 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 to be italicized.

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

  Change the style of the current cell 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 Object Toolbar

### The Object Toolbar

The Object Toolbar.

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

  This button allows the user to insert a text label into a 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 Checkbox" button. Insert a Checkbox.

  This button allows a user to insert a check box.

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.

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 a arrow at one end. A pointer.

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

  Draw a box onto the worksheet.

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

  Draw an ellipse or a circle on the worksheet.