
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.
Figure 118: 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.
Figure 119: Defining a new fill series
Using selection lists
Selection lists are available only for text, and are
limited to using only text that has already been entered
in the same column.
To use a selection list, select a blank cell and press
Ctrl+D. A drop-down list appears of any cell in the same
column that either has at least one text character or
whose format is defined as Text. Click on the entry you
require.
Chapter 5 Getting Started with Calc 159
Comentarios a estos manuales