Calc Guide

Figure 29: Typical validity test choices.
The validity test options vary with the type of data selected from the
Allow list. For example, Figure 30 shows the choices when a cell must
contain a cell range.
Figure 30: Validity choices for a cell range.
To provide input help for a cell, use the Input Help page of the Validity
dialog (Figure 31). To show an error message when an invalid value is
entered, use the Error Alert page (Figure 32). Be sure to write
something helpful, explaining what a valid entry should contain—not
just “Invalid data—try again” or something similar.
50 OpenOffice.org 3.x Calc Guide