Class | Description | |
---|---|---|
![]() | AverageConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is above or below the average or standard deviation for the associated range. |
![]() | BlanksConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is not set. |
![]() | CellConditionalFormat | Represents the aggregated conditioal format for a specific cell. It is returned via the Worksheet.GetCellConditionalFormat and the WorksheetRow.GetCellConditionalFormat methods. |
![]() | CellDataBarInfo | Exposes the information necessary for drawing a data bar for a specific cell. |
![]() | CellIconInfo | Exposes the information necessary for drawing an icon for a specific cell. |
![]() | ColorScaleConditionalFormat | Exposes properties which control the coloring of a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to minimum, midpoint, and maximum threshold values. |
![]() | ColorScaleCriterion | Defines the criterion for a ColorScaleConditionalFormat threshold. |
![]() | ConditionalFormatBase | Abstract base class for classes which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell, based on whether the cell's value meets a logical condition. |
![]() | ConditionalFormatCollection | Collection class for objects which derive from ConditionBase. |
![]() | ConditionBase | Abstract base class which encapsulates the condition for a formatting rule. |
![]() | ConditionValue | Exposes properties which define the value and its unit of measure for a conditional format threshold. |
![]() | CriterionBase | Base class for the IconCriterion and ColorScaleCriterion classes. |
![]() | DataBarConditionalFormat | Exposes properties which displays data bars in a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to the associated range. |
![]() | DateTimeConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's date/time value falls within a given range of time. |
![]() | DuplicateConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is unique or duplicated across the associated range. |
![]() | ErrorsConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is in error. |
![]() | FormulaConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value meets the criteria defined by a formula. |
![]() | IconCriterion | Defines the criterion for an IconSetConditionalFormat threshold. |
![]() | IconSetConditionalFormat | Exposes properties which displays icons in a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to threshold values. |
![]() | IconSetCriterionCollection | Collection class for objects of type IconCriterion. |
![]() | NegativeBarFormat | Exposes properties which control the appearance of negative-value data bars. |
![]() | NoBlanksConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is not set. |
![]() | NoErrorsConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value is in error. |
![]() | OperatorConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's value meets the criteria defined by a logical operator. |
![]() | RankConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is within the top or bottom rank of values across the associated range. |
![]() | TextOperatorConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether the cell's text value meets the criteria defined by a string and a FormatConditionTextOperator value. |
![]() | ThresholdConditionBase | Base class for the DataBarConditionalFormat, IconSetConditionalFormat, and ColorScaleConditionalFormat classes. |
![]() | UniqueConditionalFormat | Exposes properties which control the visual attributes of a Infragistics.Documents.Excel.WorksheetCell based on whether a cell's value is unique across the associated range. |
Enumeration | Description | |
---|---|---|
![]() | ColorScaleCriterionThreshold | Constants which identify the threshold of a ColorScaleCriterion. |
![]() | ColorScaleType | Constants which identify whether a ColorScaleConditionalFormat supports two or three thresholds. Used to differentiate between a 2-color and 3-color scale. |
![]() | DataBarAxisPosition | Constants which determine the axis position for a DataBarConditionalFormat. |
![]() | DataBarDirection | Constants which determine whether data bars are filled with a solid color or with a gradient. |
![]() | DataBarFillType | Constants which determine whether data bars are filled with a solid color or with a gradient. |
![]() | DataBarNegativeBarColorType | Constants which specify the manner in which the color for negative-value data bars is determined. |
![]() | FormatConditionAboveBelow | Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat. |
![]() | FormatConditionOperator | Constants which specify the manner in which a cell value is compared against one or more operands. |
![]() | FormatConditionTextOperator | Constants which specify the text comparison method applied when evaluating a format condition. |
![]() | FormatConditionTimePeriod | Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat. |
![]() | FormatConditionTopBottom | Constans which identify whether a RankConditionalFormat evaluates to true for the top or bottom ranked values across the associated range. |
![]() | FormatConditionType | Constants which determine the criteria for a format condition. |
![]() | FormatConditionValueType | Constants which identify the type of value which defines the criteria for a ColorScaleCriterion or IconCriterion. |
![]() | ThresholdComparison | Constants which determine the manner in which cell values are compared to the ConditionValue.Value property when conditional criteria is evaluated by an IconSetConditionalFormat. |