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

ConditionalFormatting

Class

Conditional formatting applied to one or more cell ranges, dynamically styling cells based on a formatting rule.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Model.ConditionalFormattings

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class ConditionalFormatting

Inheritance: objectConditionalFormatting

Constructors

ConditionalFormatting(ConditionalFormattingRule)

Initializes a new conditional formatting instance with the specified rule.

public ConditionalFormatting(ConditionalFormattingRule rule)

Parameters:ruleConditionalFormattingRule

Methods

Resolve(CellIndex)

double

Evaluates the conditional formatting rule for the specified cell and returns a numeric result indicating formatting status.

public double Resolve(CellIndex index)

Parameters:indexCellIndex

The index on which the formatting is applied.

Returns:

double

UpdateRule(ConditionalFormattingRule)

Replaces the current rule with a new rule and invalidates the worksheet layout with undo support.

public void UpdateRule(ConditionalFormattingRule rule)

Parameters:ruleConditionalFormattingRule

The new rule that is applied.

Properties

CellRanges

ReadOnlyCollection<CellRange>

Read-only collection of cell ranges to which this conditional formatting is applied.

public ReadOnlyCollection<CellRange> CellRanges { get; }

Rule

ConditionalFormattingRule

Rule that determines which cells receive conditional formatting and what styling is applied.

public ConditionalFormattingRule Rule { get; }

Worksheet

Worksheet to which this conditional formatting is applied; throws InvalidOperationException if accessed before the formatting is applied to a cell selection.

public Worksheet Worksheet { get; }