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

100

101

Chapter 4: Spreadsheets in Calc

9. Click cell E2, then the small filled square in the bottom right hand corner of cell E2 and,

pressing the left mouse button, drag down to cell E20.

10.Release the mouse button there.

11.The formula is now copied from E2 to E20. And all references have been automatically

adapted so that they always refer to the neighbouring cell on the left.

A Short Description of What Cells Can Contain

The previous examples show that cells can accommodate different elements. These are

described below.

Text

Text in a cell can be formatted and edited with most of the functions available in a text

document. For example, to select a word, double-click the word either in the input line or in a

cell. If a different font or other attribute from the text object bar is needed, the modifications

apply only to the selected word.

• Pressing the Ctrl+Enter keys inserts a manual line break. This shortcut only works

directly in the cell, not in the input line.

When text must break automatically at the right border of the cell, proceed as follows:

1. Select all cells in which the text should break at the right border:

2. In Format > Cell > Alignment

3. Check the Line break field

4. Click OK.

Calculations are possible even in text. For example, enter text in cell A1 and more text in A2.

In cell A3, insert the formula =CONCATENATE(A1;A2) which will concatenate the two

texts, in other words, to string them together.

Numbers may also be entered in the Text format. Format the desired cells as Text (open the

context menu of the cell, by right clicking, and choose Format Cells > Category >

Numbers > Text), and enter numbers in the cells. These will be interpreted as text. The

display of these numbers is left-justified just like normal text; however, calculations with

numbers in text format are not possible.

If normal numbers have first been entered in cells and the format of the cells has been later

changed to Text, these numbers remain normal numbers and will not be converted. Only

numbers entered later or numbers which are then edited become text numbers.

OpenOffice.org User Guide for 2.x 212

1 2 ... 241 242 243 244 245 246 247 248 249 250 251 ... 507 508

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x