OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 248)

Chapter 4: Spreadsheets in Calc

Numbers

While numbers are displayed in various ways, internally these always remain numeric. For

example, '1' and '1.0' are the same.

Enter the number 12345.6789, for example, and the number will appear in the sheet with

only two decimal places, i.e. 12345.68. Nonetheless, the exact number with all four decimal

places is kept by the program.

Fractional numbers can also be entered in a cell and used for calculation:

1. Enter 0 1/5 in a cell.

2. Press the Enter key and, in the input line, will be the value 0.2. This will be used for the

calculation providing that the cell format is number. Calc does recognize fractions and

will automatically use 1/5 and display this.

However, if 0 1/2 is entered, AutoCorrect replaces the three characters 1, / and 2 with a

single character. Likewise with 1/4 and 3/4. This replacement is defined in the Tools >

AutoCorrect > Replace tab.

If multi digit fractions such as1/ 10 are needed, change the cell format to the fraction view (

Context menu of the Cell, choose Format cells). Fractions such as 12/ 31 or 12/32 may be

entered; however, the fractions are automatically scaled down so that, in the last example,

3/8 is displayed.

Select other display options by choosing Format > Cells. All the defined formats are lists on

the Numbers tab. A preview shows how the result will look. In this dialogue, define personal

formats, that can then be applied to numbers or other content of a spreadsheets.

There are various ways to enter integers starting with a zero:

• Enter the number as text. The easiest way is to enter the number starting with an

apostrophe (for example, '0987). The apostrophe will not be entered in the cell and the

number will be formatted as text. Because it is in text format, no calculations are possible.

• Format a cell with a number format such as \0000. This format can be assigned in the

Format code box under Format > Cells... > Numbers tab and defines the cell display as

always put a zero first and then the integer, having at least three places, and filled with

zeros at the left if less than three digits.

Entire columns, (with numbers in text format i.e. in the form of 00 0123) can be turned into

real numbers again (without zeros in front of them, i.e. in the form of 123) as follows:

1. Select the column in which the digits are found in text format. Set the cell format in that

column as Number.

2. Call up Edit > Find & Replace

OpenOffice.org User Guide for 2.x 214

1 2 ... 243 244 245 246 247 248 249 250 251 252 253 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 248