• The zoom level. Double-click to modify the zoom level.
• Selection mode. Click to toggle between default mode (STD),
extended mode (EXT) and incremental mode (ADD).
• Modified flag. When the document has been modified, a star is
displayed in this area of the status bar.
• Digital signature flag. If you have added a digital signature to the
spreadsheet, a small padlock icon is displayed in this area.
Double-click to digitally sign the spreadsheet.
• Selected cells functions. By default, this area shows the sum of
the values contained in the selected cells. You can, however,
change the function used by right-clicking on the area. The
available functions are:
–
Average
(averages the values of the selection)
–
CountA
(counts the cells in the selection which are not empty)
–
Count
(counts the cells in the selection with a numeric value)
–
Maximum
(displays the maximum value in the selection)
–
Minimum
(displays the minimum value in the selection)
–
Sum
(the sum of the values in the selection)
–
None
.
Starting new spreadsheets
A new spreadsheet can be opened from any component of OOo, for
example from Writer or Draw.
From the menu bar
Click File and then select New > Spreadsheet.
From the toolbar
Use the New Document button on the Standard toolbar. (This
button is always a page of text from the current component with a
black arrow to the right.) Click the drop-down arrow for a choice of
what type of document to open (text document, spreadsheet, and so
on). Click the button itself to create a new document of the type that
is currently open (if a spreadsheet is open, a new spreadsheet
document will be created).
From the keyboard
If you already have a spreadsheet open, you can press
Control+N
to
open a new spreadsheet.
130 Getting Started with OpenOffice.org 3
Comments to this Manuals