Configures icon set conditional formatting with three threshold ranges, assigning distinct icons to cells based on which range their value falls into.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class ThreeIconSetValueContext : IconSetValueContextBaseInheritance: objectRangeValueContextBaseIconSetValueContextBaseThreeIconSetValueContext
Constructors
ThreeIconSetValueContext(IconSetRange, IconDefinition, IconSetRange, IconDefinition, IconDefinition)
Initializes a new ThreeIconSetValueContext with the specified threshold ranges and associated icons.
public ThreeIconSetValueContext(IconSetRange range1, IconDefinition icon1, IconSetRange range2, IconDefinition icon2, IconDefinition icon3)The first range.
icon1IconDefinitionThe icon that is associated with the first range.
range2IconSetRangeThe second range.
icon2IconDefinitionThe icon that is associated with the second range.
icon3IconDefinitionThe icon that is associated with the third range.
Properties
Gets or sets the icon displayed for cells whose values fall within the first range.
public IconDefinition Icon1 { get; set; }Gets or sets the icon displayed for cells whose values fall within the second range.
public IconDefinition Icon2 { get; set; }Gets or sets the icon displayed for cells whose values fall within the third range.
public IconDefinition Icon3 { get; set; }Gets or sets the first threshold range, defining the lower boundary and operator for icon assignment.
public IconSetRange Range1 { get; set; }Gets or sets the second threshold range, which automatically calculates the third range's inverse condition.
public IconSetRange Range2 { get; set; }Gets the third threshold range, automatically derived from Range2 to cover remaining values.
public IconSetRange Range3 { get; }