FormatConditionRule3ColorScale.MiddleType Property

Gets or sets the type of the midpoint of the target range.

Assembly : DevExpress.XtraEditors.v25.2.dll

NuGet Package : DevExpress.Win.Navigation

Declaration

C#
VB.NET

csharp

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

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

Property Value

Type	Default	Description
FormatConditionValueType	Automatic

The type of the midpoint of the target range.

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

To specify the target range’s midpoint, use the FormatConditionRule3ColorScale.Middle property. The type of the midpoint is set by the MiddleType property.

If the MiddleType property is set to FormatConditionValueType.Number , the FormatConditionRule3ColorScale.Middle property’s value is regarded as a number. If you choose FormatConditionValueType.Percent , the FormatConditionRule3ColorScale.Middle property specifies the percentage of the difference between the highest and lowest column values. In the case of FormatConditionValueType.Automatic mode, the midpoint is automatically set to 50%, and the FormatConditionRule3ColorScale.Middle property is ignored.