Class
SingleArgumentDataValidationRuleContext

Base configuration context for data validation rules that use a single argument expression for evaluation.

Definition

Constructors

SingleArgumentDataValidationRuleContext(Worksheet, CellIndex)

Initializes a new instance of the SingleArgumentDataValidationRuleContext class.

Declaration

cs-api-definition
public SingleArgumentDataValidationRuleContext(Worksheet worksheet, CellIndex cellIndex)

Parameters

worksheet

Worksheet

cellIndex

CellIndex

SingleArgumentDataValidationRuleContext(Worksheet, int, int)

Initializes a new instance of the SingleArgumentDataValidationRuleContext class.

Declaration

cs-api-definition
public SingleArgumentDataValidationRuleContext(Worksheet worksheet, int rowIndex, int columnIndex)

Parameters

worksheet

Worksheet

The worksheet.

rowIndex

int

Index of the row.

columnIndex

int

Index of the column.

Properties

Argument1

Expression or value used as the primary validation criterion, which may be a literal value or a formula reference.

Declaration

cs-api-definition
public string Argument1 { get; set; }

Property Value

string

The first argument.

CellIndex

Cell location where the validation rule is defined, used as the base reference for relative formula expressions.

Declaration

cs-api-definition
public CellIndex CellIndex { get; set; }

Property Value

CellIndex

The index of the cell.

IgnoreBlank

Controls whether empty cells bypass validation and are considered valid regardless of the rule.

Declaration

cs-api-definition
public bool IgnoreBlank { get; set; }

Property Value

bool

The value indicating if blank cells should be ignored.

Worksheet

Worksheet containing the validated cells, required for evaluating formula-based validation arguments.

Declaration

cs-api-definition
public Worksheet Worksheet { get; set; }

Property Value

Worksheet

The worksheet.