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
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: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also