Calc Guide

Figure 26: Result of fill series
selection shown in Figure 25
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 your own 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.
Figure 27: Predefined fill series
Click New. The Entries box is cleared. Type the series for the new list
in the Entries box (one entry per line), and then click Add.
Chapter 2 Entering, Editing, and Formatting Data 47