addIconSetRule Method

Adds an icon set rule to the rule collection.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats(worksheet);
var value; // Type: object
value = instance.addIconSetRule(iconSetTye, ranges);

function addIconSetRule( 
   iconSetTye : IconSetType,
   ranges : undefined
) : object;

Parameters

iconSetTye: The type of icon set.
ranges: The cell ranges where the rule is applied whose item type is GC.Spread.Sheets.Range.

Return Value

The icon set rule added to the rule collection.

Example

This example uses the addIconSetRule method.

Javascript

activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);
activeSheet.conditionalFormats.addIconSetRule(GC.Spread.Sheets.ConditionalFormatting.IconSetType.fourTrafficLights, [new GC.Spread.Sheets.Range(0,0,4,1)]);

Reference

ConditionalFormats type