Skip to main content

The type of data validation applied to cells in a column.

  • WholeNumber

    Only whole numbers are allowed. Once the whole number option is selected, other options become available to further limit input.

  • Decimal

    Only decimal numbers are allowed. Once the decimal number option is selected, other options become available to further limit input.

  • Date

    Only dates are allowed.

  • Time

    Only times are allowed.

  • TextLength

    Validates input based on number of characters or digits.

  • List

    Only values from a predefined list are allowed. The values are presented to the user as a dropdown menu control.