Tool

---

The Value Definition property controls the types of values that can be entered into a value object* (value cell, value field, etc). It is similar to the data validation tool in conventional spreadsheets.

Specify the type of data you want

With the Value Definition property, you can specify that a value object* must be a number, text, or from a specified option list (drop down list). You can also put restrictions on the kind of numbers that can be entered: positive, negative, compatible with certain units, etc.

Restrict a value object to numbers or text only:

1. Select the value object*.
2. Open the properties window.
3. Under Style, select Value Definition.
4. In the dropdown list, select Number or Text.
5. (Optional) Place further restrictions on the kind of number.
6. Click OK.

Restrict a value object to a list of options.

1. Select the value object*.
2. Open the properties window.
3. Under Style, select Value Definition.
4. In the dropdown list, select From Option List.
5. In the formula box, type in a formula for an array of values.
   • Type in an array directly. OR
   • Type in a reference to an array or cell range.
6. Click OK.

Notes:

• *A value object is one of the following: value cell, value field, text label, dimension label.

See also:

• Value field
• Value cell
• Text label
• Dimension label
• Arrays

---