FormatConditionIconSet.ValueType Property

Gets or sets the type of threshold values for the current icon set.

Assembly : DevExpress.XtraEditors.v25.2.dll

NuGet Package : DevExpress.Win.Navigation

Declaration

C#
VB.NET

csharp

[DefaultValue(FormatConditionValueType.Automatic)]
[DXCategory("Behavior")]
[XtraSerializableProperty]
public virtual FormatConditionValueType ValueType { get; set; }

<DefaultValue(FormatConditionValueType.Automatic)>
<XtraSerializableProperty>
<DXCategory("Behavior")>
Public Overridable Property ValueType As FormatConditionValueType

Property Value

Type	Default	Description
FormatConditionValueType	Automatic

A value that specifies the type of threshold values for the icon set.

Available values:

Name	Description
Number

Cell values are compared with zero.

| | Percent |

Cell values are compared with each other. The minimum cell value is treated as 0%, the maximum value is 100%.

| | Automatic |

A cuttoff/minimum/maximum value is calculated automatically.

When setting the FormatConditionRuleTopBottom.RankType and FormatConditionIconSet.ValueType properties, Automatic is equivalent to Number.
When setting the FormatConditionRuleMinMaxBase.MaximumType and FormatConditionRuleMinMaxBase.MinimumType properties, the maximum and minimum range values are calculated automatically, according to the FormatConditionRuleMinMaxBase.AutomaticType option.
When setting the FormatConditionRule3ColorScale.MiddleType property, a midpoint value is automatically set to 50%.

Remarks

An icon set allows you to classify a column’s values into several categories separated by threshold values, and assign a specific icon to each category. The threshold value is specified for all icons using the FormatConditionIconSetIcon.Value property.

The ValueType property defines the type of threshold values. Supported values are listed by the FormatConditionValueType enumerator.

If the ValueType property is set to Number or Automatic , the FormatConditionIconSetIcon.Value is regarded as a number. If you choose Percent , the FormatConditionIconSetIcon.Value property specifies a percentage of the difference between the highest and lowest column values.