ig.excel.FormatConditionTimePeriod

Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat.

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
  • lastMonth

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    9

    The cell's date/time value is compared to the month before the current one.

  • lastSevenDays

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    6

    The cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the CalendarWeekRule.

  • lastWeek

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    5

    The cell's date/time value is compared to the week before the current one, as defined by the CalendarWeekRule.

  • nextMonth

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    8

    The cell's date/time value is compared to the month after the current one.

  • nextWeek

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    4

    The cell's date/time value is compared to the week after the current one, as defined by the CalendarWeekRule.

  • thisMonth

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    7

    The cell's date/time value is compared to the current month.

  • thisWeek

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    3

    The cell's date/time value is compared to the current week, as defined by the CalendarWeekRule.

  • today

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    0

    The cell's date/time value is compared to the current date.

  • tomorrow

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    1

    The cell's date/time value is compared to the day after the current date.

  • yesterday

    Type:
    ig.excel.FormatConditionTimePeriod
    Default:
    2

    The cell's date/time value is compared to the day before the current date.

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

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