ig.excel.DataValidationCriteria

Determines what types of cell values are allowed and how the cell value is validated against the constraint(s).

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
  • date

    Type:
    ig.excel.DataValidationCriteria
    Default:
    4

    Dates with or without time portions are allowed as well as numbers equivalent to valid dates. When comparing against constraints, the cell value is used.

  • decimal

    Type:
    ig.excel.DataValidationCriteria
    Default:
    2

    Only numbers are allowed. When comparing against constraints, the cell value is used.

  • textLength

    Type:
    ig.excel.DataValidationCriteria
    Default:
    6

    Non-error values are allowed. When comparing against constraints, the length of the cell value's text equivalent is used.

  • time

    Type:
    ig.excel.DataValidationCriteria
    Default:
    5

    Times are allowed are well as numbers equivalent to valid times without a date portion. When comparing against constraints, the cell value is used.

  • wholeNumber

    Type:
    ig.excel.DataValidationCriteria
    Default:
    1

    Only numbers are allowed and they cannot have a fractional part. When comparing against constraints, the cell value is used.

The current widget has no events.
The current widget has no public methods.

Copyright © 1996 - 2019 Infragistics, Inc. All rights reserved.