Version

IconSetConditionalFormat Class

Exposes properties which displays icons in a Infragistics.Documents.Excel.WorksheetCell based on the cell's value as relative to threshold values.
Syntax
'Declaration
 
Public NotInheritable Class IconSetConditionalFormat 
   Inherits ThresholdConditionBase
public sealed class IconSetConditionalFormat : ThresholdConditionBase 
Remarks

This class provides the ability to display an icon inside a cell when that cell's value meets the criteria defined by the relevant IconCriterion.

Each icon set contains between three and five individual icons. The number of icons defines the number of thresholds; for example, a 3-icon set implies 3 thresholds, with each threshold representing approximately 33% of the associated range. A 4-icon set provides 4 thresholds, each representing 25% of the range; a 5-icon set contains 5 thresholds with each representing 20% of the range.

Threshold ranges are pre-defined based on the number of icons in the associated set, although this can be customized using the Value property of the IconCriterion associated with that threshold.

By default thresholds are expressed as percentages; use the Value property to customize this to support a percentile rating or a specific value. How the Value property is interpreted is dependent on the ValueType property.

While the number of thresholds is always fixed at 3, 4, or 5, the icon which is displayed for a given threshold can be customized using the Icon property.

Requirements

Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

View on GitHub