OpenOffice.org OpenOffice - 3.2 Guide de base télécharger pdf (Page 401)

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.

Expand references when new columns/rows are inserted

Specifies whether to expand references when inserting columns or

rows adjacent to the reference range. This is only possible if the

reference range, where the column or row is inserted, originally

spanned at least two cells in the desired direction.

Example: If the range A1:B1 is referenced in a formula and you

insert a new column after column B, the reference is expanded to

A1:C1. If the range A1:B1 is referenced and a new row is inserted

under row 1, the reference is not expanded, since there is only a

single cell in the vertical direction.

If you insert rows or columns in the middle of a reference area, the

reference is always expanded.

Highlight selection in column/row headings

Specifies whether to highlight column and row headers in the

selected columns or rows.

Chapter 14 Setting up and Customizing Calc 401

1 2 ... 396 397 398 399 400 401 402 403 404 405 406 ... 496 497

Pas de commentaire

OpenOffice.org OpenOffice - 3.2 Guide de base Page 401