FormatConditionRule3ColorScale.MiddleType Property
Gets or sets the type of the midpoint of the target range.
Namespace: DevExpress.XtraEditors
Assembly: DevExpress.XtraEditors.v23.2.dll
NuGet Package: DevExpress.Win.Navigation
Declaration
[DefaultValue(FormatConditionValueType.Automatic)]
[DXCategory("Behavior")]
[XtraSerializableProperty]
public FormatConditionValueType MiddleType { get; set; }
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.
|
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.