New to Telerik Document Processing? Start a free 30-day trial

IconSetRule

Class

Displays icons in cells based on numeric value thresholds, categorizing data into 3, 4, or 5 ranges with distinct visual indicators.

Definition

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class IconSetRule : ConditionalFormattingRule

Initializes a new IconSetRule with a custom icon set value context defining thresholds and icons.

public IconSetRule(IconSetValueContextBase values)

Initializes a new IconSetRule with a preset icon set and optional reversal of icon order.

public IconSetRule(PresetIconSet presetIconSet, bool isReversed = false)

Parameters:presetIconSetPresetIconSetisReversedbool

Gets whether the icon set order is reversed, swapping icons for highest and lowest value ranges.

public bool IsReversed { get; }

Gets or sets whether only the icon is visible, hiding the underlying numeric cell value.

public bool ShowIconOnly { get; set; }

Gets the icon set value context that defines the value thresholds and associated icons for each range.

public IconSetValueContextBase ValueContext { get; }