Condition type

Represents a conditional item using the parameter object.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args);

function Condition;

Example

Javascript

var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.averageCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.AverageConditionType.above});
nCondition.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 3)]);
var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
validator.type(GC.Spread.Sheets.DataValidation.CriteriaType.custom);
activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
spread.options.highlightInvalidData = true;
activeSheet.setValue(0, 0, 5);
activeSheet.setValue(1, 0, 15);

Inheritance Hierarchy

Object
GC.Spread.Sheets.ConditionalFormatting.Condition

Constructors

	Name	Description
	Condition Constructor	Represents a conditional item using the parameter object.

Top

Methods

	Name	Description
	compareType	Gets or sets the rule compare type.
	evaluate	Evaluates the condition using the specified evaluator.
	expected	Gets or sets the expected value.
	formula	Gets or sets the expected formula.
	fromDay	Creates a date extend condition object from the specified day.
	fromFormula	Creates the area condition from formula data.
	fromMonth	Creates a date extend condition object from the specified month.
	fromQuarter	Creates a date extend condition object from the specified quarter.
	fromSource	Creates the area condition from source data.
	fromWeek	Creates a date extend condition object from the specified week.
	fromYear	Creates a date extend condition object from the specified year.
	getExpected	Gets the expected value.
	getValidList	Returns the list of valid data items.
	ignoreBlank	Gets or sets whether to ignore the blank cell.
	ignoreCase	Gets or sets whether to ignore case when performing the comparison.
	item1	Gets or sets the first condition.
	item2	Gets or sets the second condition.
	ranges	Gets or sets the condition ranges.
	reset	Resets this instance.
	treatNullValueAsZero	Gets or sets whether to treat the null value in a cell as zero.
	useWildCards	Gets or sets whether to compare strings using wildcards.

Top

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace