OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 46)

Text that you type: Result

A - B (A, space, minus, space, B) A – B (A, space, en-dash, space, B)

A -- B (A, space, minus, minus, space, B) A – B (A, space, en-dash, space, B)

A--B (A, minus, minus, B) A—B (A, em-dash, B)

A-B (A, minus, B) A-B (unchanged)

A -B (A, space, minus, B) A -B (unchanged)

A --B (A, space, minus, minus, B) A –B (A, space, en-dash, B)

Deactivating automatic changes

Calc automatically applies many changes during data input, unless you deactivate

those changes. You can also immediately undo any automatic changes with Ctrl+Z.

AutoCorrect changes

Automatic correction of typing errors, replacement of straight quotation marks by

curly (custom) quotes, and starting cell content with an uppercase (capital) letter

are controlled by Tools > AutoCorrect Options. Go to the Options or Replace

tabs to deactivate any of the features that you do not want. On the Replace tab,

you can also delete unwanted word pairs and add new ones as required.

AutoInput

When you are typing in a cell, Calc automatically suggests matching input found

in the same column. To turn the AutoInput on and off, set or remove the check

mark in front of Tools > Cell Contents > AutoInput.

Automatic date conversion

Calc automatically converts certain entries to dates. To ensure that an entry that

looks like a date is interpreted as text, type an apostrophe at the beginning of the

entry. The apostrophe is not displayed in the cell.

Speeding up data entry

Entering data into a spreadsheet can be very labor-intensive, but Calc provides

several tools for removing some of the drudgery from input.

The most basic ability is to drop and drag the contents of one cell to another with a

mouse. Many people also find AutoInput helpful. Calc also includes several other

tools for automating input, especially of repetitive material. They include the Fill tool,

selection lists, and the ability to input information into multiple sheets of the same

document.

Using the Fill tool on cells

At its simplest, the Fill tool is a way to duplicate existing content. Start by selecting

the cell to copy, then drag the mouse in any direction (or hold down the Shift key and

click in the last cell you want to fill), and then choose Edit > Fill and the direction in

which you want to copy: Up, Down, Left or Right.

46 OpenOffice.org 3.3 Calc Guide

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 46