OpenOffice.org Calc functions
similarly to other spreadsheet applications. It is useful for
creating forms as well as calculations.
To create a new spreadsheet:
Start OpenOffice.org Calc from
the Applications menu bu going
to Application =>
Office =>
OpenOffice.org Calc or enter
oocalc at a shell prompt.
Enter text, numbers, or functions.
To open an existing spreadsheet:
With OpenOffice.org Calc open,
go to File =>
Open, click on the
Folder icon, or press
[Ctrl]-[O].
Navigate to the location of the spreadsheet.
Double-click on the spreadsheet name or click once to
highlight it and then click the OK button.
To save a spreadsheet:
Click on the floppy disk icon, go to
File =>
Save, or go to
File => Save
As.
A window opens that shows your file system. If you have
already saved this file before, you won't have to do
anything else.
Navigate to the lcoation you would like to save your file
in.
Enter a name for your file in the File
name field.
Select the format for your file from the File
type drop down menu.
Click on the Save button.
To print a spreadsheet:
Click on the printer icon or go to
File =>
Print or press
[Ctrl]-[P].
A window opens with print configuration options.
Select the options you would like.
Click on the OK button.
To manually enter a function:
Select the cell where the function should be placed.
Enter the function: start with an "=" sign
and enter the name of the function.
To use cells in the argument of the
function (the part of the function that is operated on),
enter an open parenthesis, "(", and then
highlight the cells with your mouse. You can also type in
the cell names after the open parenthesis.
Press [Enter] to enter the function and
calculate the result.
To enter a function using the Function
AutoPilot:
Select the cell where the function should go.
Go to Insert =>
Function or press
[Ctrl]-[F2].
The AutoPilot window opens.
Select the function you would like to use from the pane on
the left. You select by double-clicking on the name of the
function.
In the right pane, information about the selected function
is displayed. Fields for the data are just below the
function information. Lastly, a box displays the result
of your calculation.
To select cells to use in your function, click on the
Shrink icon next to the field these
cells will be entered.
Highlight the cells with your mouse. Press
[Enter] to return to
AutoPilot
When finished, click the OK button.
To use conditional formatting:
Go to Format =>
Conditional
Formatting...
A window opens with formatting options.
Select whether the condition applies to a cell or a
function in the far left.
Select the condition of the relationship in the next
drop-down box.
In the next field, either enter a value or select cells.
In the Cell Style drop-down menu,
select what the resulting style should be.
To change cell format:
Select the cells to outline by highlighting them with the
mouse.
Go to Format =>
Cells and select the
Borders tab, or click the
Borders icon on the Object
Bar toolbar.
On the Borders tab, choose the color,
position, weight, and line type of your borders. Click
the OK button to apply these
borders.
The small blue arrow in the upper right of the
Borders icon opens a drop-down menu.
Double-click the image that represents the borders to
apply to your selection.
To create a chart:
Select the data to use for the chart by highlighting with
the mouse.
Go to Insert =>
Chart.
The AutoFormat Chart window
opens.
Select where you want your chart displayed and click
Next >>.