SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / IconCriterion class
In This Topic
    IconCriterion class
    In This Topic
    Represents an icon criteria with the specified parameters.
    Syntax
    var instance = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(isGreaterThanOrEqualTo, iconValueType, iconValue);
    function IconCriterion;
    Example
    //This example creates an icon rule.
    activeSheet.setValue(0,0,1,3);
    activeSheet.setValue(1,0,15,3);
    activeSheet.setValue(2,0,25,3);
    activeSheet.setValue(3,0,-1,3);
    //rule
    var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();
    iconSetRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
    iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.fourTrafficLights);
    var iconCriteria = iconSetRule.iconCriteria();
    iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 1);
    iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 10);
    iconCriteria[2] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 20);
    iconSetRule.reverseIconOrder(false);
    iconSetRule.showIconOnly(false);
    activeSheet.conditionalFormats.addRule(iconSetRule);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.IconCriterion

    Constructors
     NameDescription
    public ConstructorRepresents an icon criteria with the specified parameters.  
    Top
    See Also