Calc Guide

Automatically find column and row labels
Specifies that you can use the text in any cell as a label for the
column below the text or the row to the right of the text. The text
must consist of at least one word and must not contain any
operators.
Example: Cell E5 contains the text Europe. Below, in cell E6, is the
value 100 and in cell E7 the value 200. If the Automatically find
column and row labels option is selected, you can write the
following formula in cell A1: =SUM(Europe).
Sort Lists options
In the Options dialog, choose OpenOffice.org Calc > Sort Lists. Sort
lists are used for more than sorting, for example filling a series of cells
during data entry. In addition to the supplied lists, you can define and
edit your own lists, as described in “Defining a fill series” in Chapter 2
(Entering, Editing, and Formatting Data).
Figure 325: Defining sorting lists in Calc
Chapter 14 Setting up and Customizing Calc 407