ValueDefinitionProperty

Tool

You can refer to this tool in any formula, macro, module, or other script in Blockpad. You can use either its name or its full path:

  • To refer to it by name, use ValueDefinitionProperty (make sure the library Library.Tools.Properties is included with Include Libaries)
  • To refer to it by its full path, use Library.Tools.Properties.ValueDefinitionProperty

 

See also:

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:
See also: