Operation Manual

Calc toolbars can be either docked and fixed in place, or floating allowing you to move a toolbar
into a more convenient position on your workspace. Docked toolbars can be undocked and moved
to different docked position on the workspace or undocked to become a floating toolbar. Toolbars
that are floating when opened can be docked into a fixed position on your workspace.
The default set of icons (sometimes called buttons) on toolbars provide a wide range of common
commands and functions. You can also remove or add icons to toolbars, see Chapter 14
Customizing LibreOffice for more information.
Formula bar
The Formula Bar is located at the top of the sheet in your Calc workspace. The Formula Bar is
permanently docked in this position and cannot be used as a floating toolbar. If the Formula Bar is
not visible, go to View on the main menu bar and select Formula Bar.
Figure 90: Formula bar
Going from left to right and referring to Figure 90, the Formula Bar consists of the following:
• Name Box – gives the cell reference using a combination of a letter and number, for
example A1. The letter indicates the column and the number indicates the row of the
selected cell.
• Function Wizard – opens a dialog from which you can search through a list of
available functions. This can be very useful because it also shows how the functions are
formatted.
• Sum – clicking on the Sum icon totals the numbers in the cells above the selected cell
and then places the total in the selected cell. If there are no numbers above the selected
cell, then the cells to the left are totaled.
• Function – clicking on the Function icon inserts an equals (=) sign into the selected cell
and the Input line allowing a formula to be entered.
• Input line – displays the contents of the selected cell (data, formula, or function) and
allows you to edit the cell contents.
• You can also edit the contents of a cell directly in the cell itself by double clicking on the
cell. When you enter new data into a cell, the Sum and Function icons change to Cancel
and Accept icons .
Note
In a spreadsheet the term function covers much more than just mathematical
functions. See the Calc Guide Chapter 7 Using Formulas and Functions in for more
information.
Spreadsheet layout
Individual cells
The main section of the workspace in Calc displays the cells in the form of a grid. Each cell is
formed by the intersection of the columns and rows in the spreadsheet.
At the top of the columns and the left end of the rows are a series of header boxes containing
letters and numbers. The column headers use an alpha character starting at A and go on to the
right. The row headers use a numerical character starting at 1 and go down.
114 | Getting Started with LibreOffice 4.0