Class
ContainsBlanksRule

Conditional formatting rule that applies formatting when a cell is blank or contains only whitespace.

Definition

Constructors

ContainsBlanksRule()

Initializes a new ContainsBlanksRule with default formatting.

Declaration

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

ContainsBlanksRule(DifferentialFormatting)

Initializes a new ContainsBlanksRule with the specified formatting to apply when the condition is met.

Declaration

cs-api-definition
public ContainsBlanksRule(DifferentialFormatting formatting)

Parameters

formatting

DifferentialFormatting

Methods

Resolve(ICellValue)

Evaluates whether the cell is blank or contains only whitespace 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)