Spread.Sheets Documentation
addIconSetRule Method
GC.Spread.Sheets.ConditionalFormatting Namespace > ConditionalFormats type : addIconSetRule Method
The type of icon set.
The cell ranges where the rule is applied whose item type is GC.Spread.Sheets.Range.
Adds an icon set rule to the rule collection.
Syntax
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.
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)]);
See Also

Reference

ConditionalFormats type