Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TdxSpreadSheetConditionalFormattingRuleIconSet.PresetName Property

Specifies the identifier name of the icon preset that corresponds to the rule’s threshold points.

#Declaration

Delphi
property PresetName: string read; write;

#Property Value

Type Description
string

The name of the active icon preset.

You can call the global ConditionalFormattingIconSet function to access the icon preset collection.

#Remarks

The Icon Set conditional formatting rule ships with 19 icon presets available for selection. Refer to the TdxSpreadSheetConditionalFormattingIconSet.Presets property description for the full list of available icon sets.

Use the PresetName property to switch between available icon presets for the Icon Set conditional formatting rule.

#Code Example: Apply an Icon Set Conditional Formatting Rule to a Data Grid Column

The following code example creates an Icon Set conditional formatting rule with three threshold values and applies the rule to the first column in a TcxGrid control’s data-aware Table View:

var
  ARule: TdxSpreadSheetConditionalFormattingRuleIconSet;
begin
  cxGrid1DBTableView1.ConditionalFormatting.Add(0, TdxSpreadSheetConditionalFormattingRuleIconSet, ARule);
  ARule.BeginUpdate;  // Initiates the following batch change
  try
    ARule.PresetName := ConditionalFormattingIconSet.Presets.Items[1].Name;
    ARule.Stops[0].ValueType := cssvtValue;
    ARule.Stops[0].Value := 0;
    ARule.Stops[1].ValueType := cssvtValue;
    ARule.Stops[1].Value := 25;
    ARule.Stops[2].ValueType := cssvtValue;
    ARule.Stops[2].Value := 50;
  finally  
    ARule.EndUpdate;  // Calls EndUpdate regardless of the batch operation's success
  end;
end;

#Default Value

The PresetName property’s default value is an empty string.

The default PresetName property value indicates that the 3 Arrows preset is active. The Icon Set rule also uses this icon preset if you assign a name that does not match one of the preset names in the global icon preset collection.

See Also