Impress Guide

Figure 117: The menu bar and the formatting toolbar in
spreadsheet editing mode
One of the most important changes is the presence of the Formula
toolbar, just below the Formatting toolbar. The Formula toolbar
contains (from left to right):
• The active cell reference or the name of the selected range
• The Formula Wizard button
• The Sum and Formula buttons or the Cancel and Accept buttons
(depending on the contents of the cell)
• A long edit box to enter or review the contents of a cell
If you are familiar with Calc, you will immediately recognize the tools
and the menu items since they are much the same.
Resizing and moving a spreadsheet
When resizing or moving a spreadsheet, ignore the first row and the
first column (easily recognizable because of their light gray
background) and the horizontal and vertical scroll bars). They are only
used for editing purposes and will not be included in the visible area of
the spreadsheet on the slide.
To resize the area occupied by the spreadsheet:
1) Double-click to enter the edit mode, if it is not already active.
Notice the black handles found in the gray border surrounding
the spreadsheet (see Figure 116).
2) Move the mouse over one of the handles. The cursor changes
shape to give a visual representation of the effects applied to the
area.
3) Click and hold the left mouse button and drag the handle. The
corner handles resize the two sides forming the corner
simultaneously, while the handles in the middle of the sides
modify one dimension at a time.
158 OpenOffice.org Impress Guide