SpreadJS 13
GC.Spread.Sheets.ConditionalFormatting Namespace / IconSetType Enumeration
In This Topic
    IconSetType Enumeration
    In This Topic
    Specifies the icon set.
    Members
    MemberDescription
    fiveArrowsColoredSpecifies five colored arrows.
    fiveArrowsGraySpecifies five gray arrows.
    fiveBoxesSpecifies five boxes.
    fiveQuartersSpecifies five quarters.
    fiveRatingsSpecifies five ratings.
    fourArrowsColoredSpecifies four colored arrows.
    fourArrowsGraySpecifies four gray arrows.
    fourRatingsSpecifies four ratings.
    fourRedToBlackSpecifies four red to black icons.
    fourTrafficLightsSpecifies four traffic lights.
    noIconsSpecifies no cell icon.
    threeArrowsColoredSpecifies three colored arrows.
    threeArrowsGraySpecifies three gray arrows.
    threeFlagsSpecifies three flags.
    threeSignsSpecifies three signs.
    threeStarsSpecifies three stars.
    threeSymbolsCircledSpecifies three symbols (circled).
    threeSymbolsUncircledSpecifies three symbols (uncircled).
    threeTrafficLightsRimmedSpecifies three traffic lights (rimmed).
    threeTrafficLightsUnrimmedSpecifies three traffic lights (unrimmed).
    threeTrianglesSpecifies three trangles.
    Example
    This example creates a 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);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.ConditionalFormatting.IconSetType

    See Also