OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

1.

Select the Range to Validate

Select the cell or range that you want to create a data validity check for. For example, you may want to create a range of dates and disallow any entry into the range that is not a valid date.

To add the data validity check, select

Data, Validity to display the

Validity dialog box.

2.

Set Up Criteria

On the

Criteria page, you set up the criteria to which the range must conform before the user can enter a value. For example, if you require a date that falls after January 1, 2006, you would select

Date from the

Allow field. Keep the

Allow blanks option checked if you want to allow blanks in the range without the blanks violating the criteria.

Select a condition from the

Data field that the range must meet. For example, to allow the entry of dates January 1, 2006 and after, you would select

greater than . Then, you'd type 1/1/2006 in the

Minimum field. The

Maximum field appears if you select either

between or

not between so that you can define the two fields that limit the input range.

128 About OpenOffice.org Macros for more information about macros.

5.

Test Validity

Test your data validity check by typing data in the cell. When you select the cell, the

Input Help message should appear, telling you what data the cell expects. If you enter a value that violates the criteria, Calc responds with a warning or a pop-up dialog box, depending on how you set up the error alert.