SpreadJS 14
GC.Spread.Sheets.ConditionalFormatting Namespace / Condition type
In This Topic
    Condition type
    In This Topic
    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 MethodGets or sets the expected formula.  
    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 whether to compare whole day or precise date time.  
    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