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. |