CellValueCondition type

Represents a cell value condition with a specified compare type, expected value, and formula.

Syntax

var instance = new GcSpread.Sheets.CellValueCondition(compareType, expected, formula);

function CellValueCondition;

Inheritance Hierarchy

Object
GcSpread.Sheets.CellValueCondition

Constructors

	Name	Description
	CellValueCondition Constructor	Represents a cell value condition with a specified compare type, expected value, and formula.

Fields

	Name	Description
	compareType	Indicates the type of comparison.
	expected	Indicates the expected value.
	formula	Indicates the formula that specifies a cell.
	treatNullValueAsZero	Indicates whether to treat the null value in a cell as zero.

Methods

	Name	Description
	evaluate	Evaluates the condition using the specified evaluator.
	getExpected	Gets the expected value.
	isSatisfyingCondition	Determines whether the specified value meets the condition.