SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / IconCriterion class / IconCriterion Constructor
If set to true, use the greater than or equal to operator to calculate the value.
The type of scale value.
The scale value.
In This Topic
    IconCriterion Constructor
    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( 
       isGreaterThanOrEqualTo : boolean,
       iconValueType : IconValueType,
       iconValue : Object
    ) : IconCriterion;

    Parameters

    isGreaterThanOrEqualTo
    If set to true, use the greater than or equal to operator to calculate the value.
    iconValueType
    The type of scale value.
    iconValue
    The scale value.
    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);
    
    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);
    See Also