OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 156)

100

101

Caution

When a number is formatted as text, take care that the cell

containing the number is not used in a formula because Calc

will ignore the value.

Entering dates and times

Select the cell and type the date or time. You can separate the date

elements with a slant (/) or a hyphen (–) or use text such as 10 Oct 03.

Calc recognizes a variety of date formats. You can separate time

elements with colons such as 10:43:45.

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 Custom Quotes, 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.

156 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 151 152 153 154 155 156 157 158 159 160 161 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 156

Comentarios a estos manuales

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 156

Comentarios a estos manuales

Relacionado con productos y manuales para Software De Gráficos OpenOffice.org OpenOffice - 3.2