| GC.Spread.Sheets.ConditionalFormatting Namespace : IconSetType Enumeration |
| Member | Description |
|---|---|
| fiveArrowsColored | Specifies five colored arrows. |
| fiveArrowsGray | Specifies five gray arrows. |
| fiveBoxes | Specifies five boxes. |
| fiveQuarters | Specifies five quarters. |
| fiveRatings | Specifies five ratings. |
| fourArrowsColored | Specifies four colored arrows. |
| fourArrowsGray | Specifies four gray arrows. |
| fourRatings | Specifies four ratings. |
| fourRedToBlack | Specifies four red to black icons. |
| fourTrafficLights | Specifies four traffic lights. |
| threeArrowsColored | Specifies three colored arrows. |
| threeArrowsGray | Specifies three gray arrows. |
| threeFlags | Specifies three flags. |
| threeSigns | Specifies three signs. |
| threeStars | Specifies three stars. |
| threeSymbolsCircled | Specifies three symbols (circled). |
| threeSymbolsUncircled | Specifies three symbols (uncircled). |
| threeTrafficLightsRimmed | Specifies three traffic lights (rimmed). |
| threeTrafficLightsUnrimmed | Specifies three traffic lights (unrimmed). |
| threeTriangles | Specifies three trangles. |
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);
Object
GC.Spread.Sheets.ConditionalFormatting.IconSetType