Calc Guide

General options for Calc
In the Options dialog, choose OpenOffice.org Calc > General.
Figure 339: Selecting general options for Calc
Metrics section
Choose the unit of measurement used in spreadsheets and the default tab stops
distance.
Updating section
Choose whether to update links when opening a document always, only on request,
or never. Regardless of this setting, you can manually update links at any time. You
might want to avoid updating links when opening documents if they often contain
many charts or linked graphics that would slow down loading.
Input settings section
Press Enter to move selection
Specifies that pressing Enter moves the cursor to another cell. If this option is
selected, you can also choose the direction the cursor moves: up, down, left, or
right. If this option is not selected, pressing Enter completes data entry for a cell
but does not move the cursor.
Press Enter to switch to edit mode
Specifies that pressing Enter puts the selected cell into edit mode.
Expand formatting
Specifies whether to automatically apply the formatting attributes of an inserted
cell to empty adjacent cells. If, for example, an inserted cell has the bold attribute,
this attribute will also apply to empty adjacent cells. However, cells that already
have a special format will not be modified by this function. To see the affected
range, press Ctrl+* (multiplication sign on the number pad). The format will also
apply to all new values inserted within this range.
Chapter 14 Setting up and Customizing Calc 351