Liquid UI - WS Reference Library

3.2.2 List Validation

Case 1: List Validation

The second case is that validation will be performed according to a pre-specified list of values. To set this case, if it not already selected, please do the following.
  1. Right-click on a cell in the row you want to validate and choose Data Validation from the context menu.

  2. The Data Validation wizard will appear as shown below.

  3. Select the List radiobutton if it is not already selected as shown below and then click Next.

  4. The value entry screen will display as shown below. Click the Add button.

  5. The Input Data dialog will appear as shown below. Enter a value. in our example, we entered OR.

  6. Repeat the data input for as many values as you want to include in your list. When you are done, click Next.

  7. The Finish window will display as shown below. Click Finish.

  8. The List Validation case has now been set for this row.