Skip to main content

TdxSpreadSheetConditionalFormattingIconSet.Presets Property

Provides access to the collection of all icon presets currently available for use in “Icon Set“ conditional formatting rules.

Declaration

property Presets: TdxSpreadSheetConditionalFormattingIconSetPresets read;

Property Value

Type
TdxSpreadSheetConditionalFormattingIconSetPresets

Remarks

The Presets collection includes 19 predefined presets. To use a specific preset in an “Icon Set” conditional formatting rule, assign the corresponding preset identifier name to the rule’s PresetName property:

No. Identifier Name Descriptive Name Preset Preview
1. ‘3Arrows’ ‘3 Arrows’
2. ‘3ArrowsGray’ ‘4 Arrows (Gray)’
3. ‘3Flags’ ‘3 Flags’
4. ‘3Signs’ ‘3 Signs’
5. ‘3Symbols’ ‘3 Symbols (Circled)’
6. ‘3Symbols2’ ‘3 Symbols’
7. ‘3TrafficLights1’ ‘3 Traffic Lights’
8. ‘3TrafficLights2’ ‘3 Traffic Lights (Rimmed)’
9. ‘3Triangles’ ‘3 Triangles’
10. ‘4Arrows’ ‘4 Arrows’
11. ‘4ArrowsGray’ ‘4 Arrows (Gray)’
12. ‘4Rating’ ‘4 Ratings’
13. ‘4RedToBlack’ ‘Red to Black’
14. ‘4TrafficLights’ ‘4 Traffic Lights’
15. ‘5Arrows’ ‘5 Arrows’
16. ‘5ArrowsGray’ ‘5 Arrows (Gray)’
17. ‘5Boxes’ ‘5 Boxes’
18. ‘5Quarters’ ‘5 Quarters’
19. ‘5Rating’ ‘5 Ratings’

You can call the Presets.Add function to create custom icon presets from the predefined list of source icons. Refer to the TdxSpreadSheetConditionalFormattingIconSetPresets class description for detailed information on all available options.

Note

The image list containing the icon preset previews does not update in response to changes made to the Presets collection.

See Also