Class
ContainsRule

Conditional formatting rule that applies formatting when a cell's text value contains a specified substring.

Definition

Constructors

ContainsRule(string)

Initializes a new ContainsRule with the text substring to search for.

Declaration

cs-api-definition
[Obsolete("This constructor is obsoleted, please use the one with formatting parameter instead.")]
public ContainsRule(string argument)

Parameters

argument

string

ContainsRule(string, DifferentialFormatting)

Initializes a new ContainsRule with the text substring to search for and formatting to apply when the condition is met.

Declaration

cs-api-definition
public ContainsRule(string argument, DifferentialFormatting formatting)

Parameters

argument

string

formatting

DifferentialFormatting

Methods

Resolve(ICellValue)

Evaluates whether the cell's text value contains the specified substring and returns 1.0 if true, 0.0 otherwise.

Declaration

cs-api-definition
protected override double Resolve(ICellValue value)

Parameters

value

ICellValue

The cell value

Returns

double

Overrides ConditionalFormattingRule.Resolve(ICellValue)