Spread.Sheets Documentation
Condition type
GC.Spread.Sheets.ConditionalFormatting Namespace : Condition type
Represents a conditional item using the parameter object.
Syntax
var instance = new GC.Spread.Sheets.ConditionalFormatting.Condition(conditionType, args);
function Condition;
Example
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
 NameDescription
public ConstructorRepresents a conditional item using the parameter object.  
Top
Methods
 NameDescription
public MethodGets or sets the rule compare type.  
public MethodEvaluates the condition using the specified evaluator.  
public MethodGets or sets the expected value.  
public Method  
public Methodstatic (Shared in Visual Basic)Creates a date extend condition object from the specified day.  
public Methodstatic (Shared in Visual Basic)Creates the area condition from formula data.  
public Methodstatic (Shared in Visual Basic)Creates a date extend condition object from the specified month.  
public Methodstatic (Shared in Visual Basic)Creates a date extend condition object from the specified quarter.  
public Methodstatic (Shared in Visual Basic)Creates the area condition from source data.  
public Methodstatic (Shared in Visual Basic)Creates a date extend condition object from the specified week.  
public Methodstatic (Shared in Visual Basic)Creates a date extend condition object from the specified year.  
public MethodGets the expected value.  
public MethodReturns the list of valid data items.  
public MethodGets or sets whether to ignore the blank cell.  
public MethodGets or sets whether to ignore case when performing the comparison.  
public MethodGets or sets the first condition.  
public MethodGets or sets the second condition.  
public MethodGets or sets the condition ranges.  
public MethodResets this instance.  
public MethodGets or sets whether to treat the null value in a cell as zero.  
public MethodGets or sets whether to compare strings using wildcards.  
Top
See Also

Reference

GC.Spread.Sheets.ConditionalFormatting Namespace