Operation Manual

Toolbars
The default setting when Calc opens is for the Standard and Formatting toolbars to be docked at
the top of the workspace (Figure 88).
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 either
moved to different docked position on the workspace, or left as 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 the 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 Menu bar and select Formula Bar.
Figure 89: Formula bar
Going from left to right and referring to Figure 89, the Formula Bar consists of the following:
• Name Box – gives the current active 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 for more
information.
Chapter 5 Getting Started with Calc | 115