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

100

101

To add a fill series to a spreadsheet, select the cells to fill, choose Edit

> Fill > Series. In the Fill Series dialog, select AutoFill as the

Series

type

, and enter as the

Start value

an item from any defined series. The

selected cells then fill in the other items on the list sequentially,

repeating from the top of the list when they reach the end of the list.

Figure 111: Specifying the start of a fill series (result is in Figure 112)

You can also use Edit > Fill > Series

to create a one-time fill series for

numbers by entering the start and end

values and the increment. For example,

if you entered start and end values of 1

and 7 with an increment of 2, you would

get the sequence of 1, 3, 5, 7.

In all these cases, the Fill tool creates

only a momentary connection between

the cells. Once they are filled, the cells

have no further connection with one

another.

Defining a fill series

To define a fill series, go to Tools > Options > OpenOffice.org Calc

> Sort Lists. This dialog shows the previously-defined series in the

Lists

box on the left, and the contents of the highlighted list in the

Entries

box.

148 Getting Started with OpenOffice.org 3

Figure 112: Result of fill series

selection shown in Figure 111

1 2 ... 143 144 145 146 147 148 149 150 151 152 153 ... 432 433

Comentarios a estos manuales

Sin comentarios

OpenOffice.org OpenOffice - 3.0 Guía de inicio rápido Pagina 148

Comentarios a estos manuales

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