Class ConditionalFormatting

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

Inheritance

System.Object

ConditionalFormatting

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

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

Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class ConditionalFormatting

Constructors

ConditionalFormatting(ConditionalFormattingRule)

Initializes a new conditional formatting instance with the specified rule.

Declaration

public ConditionalFormatting(ConditionalFormattingRule rule)

Parameters

ConditionalFormattingRule rule

Properties

CellRanges

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

Declaration

public ReadOnlyCollection<CellRange> CellRanges { get; }

Property Value

System.Collections.ObjectModel.ReadOnlyCollection<CellRange>

Rule

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

Declaration

public ConditionalFormattingRule Rule { get; }

Property Value

ConditionalFormattingRule

Worksheet

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

Declaration

public Worksheet Worksheet { get; }

Property Value

Worksheet

Methods

Resolve(CellIndex)

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

Declaration

public double Resolve(CellIndex index)

Parameters

CellIndex index The index on which the formatting is applied.

Returns

System.Double

UpdateRule(ConditionalFormattingRule)

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

Declaration

public void UpdateRule(ConditionalFormattingRule rule)

Parameters

ConditionalFormattingRule rule The new rule that is applied.