Getting Started Guide

Figure 110: Specifying the start of a fill series (result is in Figure 109)
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:
1) 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 111: Predefined fill series
2) Click New. The Entries box is cleared.
3) Type the series for the new list in the Entries box (one entry per line). Click
Add. The new list will now appear in the Lists box.
4) Click OK at the bottom of the dialog to save the new list.
126 Getting Started with OpenOffice.org 3.3