ig.excel.DateTimeConditionalFormat

Exposes properties which control the visual attributes of a WorksheetCell based on whether a cell's date/time value falls within a given range of time.

Remarks

This condition can be used to control the visual attributes of cells with date/time values which fall within a range of time as specified by the DateTimeConditionalFormat.dateOperator property.

This condition provides only limited support for defining date/time ranges, i.e., the current, previous, or next day, week or month. For wider ranges, or more precise conditions, use the FormulaConditionalFormat class, and assign the desired date/time formula to the FormulaConditionalFormat.formula property.

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
The current widget has no options.
The current widget has no events.
  • dateOperator

    .dateOperator( );

    Returns a FormatConditionTimePeriod value which defines the range of time against which cell values are compared when evaluating this condition.

  • dateOperator

    .dateOperator( value:ig.excel.FormatConditionTimePeriod );

    Sets a FormatConditionTimePeriod value which defines the range of time against which cell values are compared when evaluating this condition.

    • value
    • Type:ig.excel.FormatConditionTimePeriod

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