New to Telerik Document ProcessingStart a free 30-day trial

Configures icon set conditional formatting with four 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:

C#
public class FourIconSetValueContext : IconSetValueContextBase

Inheritance: objectRangeValueContextBaseIconSetValueContextBaseFourIconSetValueContext

Constructors

Initializes a new FourIconSetValueContext with the specified threshold ranges and associated icons.

C#
public FourIconSetValueContext(IconSetRange range1, IconDefinition icon1, IconSetRange range2, IconDefinition icon2, IconSetRange range3, IconDefinition icon3, IconDefinition icon4)
Parameters:range1IconSetRange

The first range.

icon1IconDefinition

The icon that is associated with the first range.

range2IconSetRange

The second range.

icon2IconDefinition

The icon that is associated with the second range.

range3IconSetRange

The third range.

icon3IconDefinition

The icon that is associated with the third range.

icon4IconDefinition

The icon that is associated with the fourth range.

Properties

Gets or sets the icon displayed for cells whose values fall within the first range.

C#
public IconDefinition Icon1 { get; set; }

Gets or sets the icon displayed for cells whose values fall within the second range.

C#
public IconDefinition Icon2 { get; set; }

Gets or sets the icon displayed for cells whose values fall within the third range.

C#
public IconDefinition Icon3 { get; set; }

Gets or sets the icon displayed for cells whose values fall within the fourth range.

C#
public IconDefinition Icon4 { get; set; }

Gets or sets the first threshold range, defining the lower boundary and operator for icon assignment.

C#
public IconSetRange Range1 { get; set; }

Gets or sets the second threshold range, defining the next boundary and operator for icon assignment.

C#
public IconSetRange Range2 { get; set; }

Gets or sets the third threshold range, which automatically calculates the fourth range's inverse condition.

C#
public IconSetRange Range3 { get; set; }

Gets the fourth threshold range, automatically derived from Range3 to cover remaining values.

C#
public IconSetRange Range4 { get; }