Skip to main content
A newer version of this page is available. .

XlCondFmtValueObject.ObjectType Property

Gets or sets the type of the threshold value specified in the conditional formatting rule.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.2.Core.dll

Declaration

public XlCondFmtValueObjectType ObjectType { get; set; }

Property Value

Type Description
XlCondFmtValueObjectType

One of the XlCondFmtValueObjectType enumeration values.

Available values:

Name Description
Number

Indicates that a number value is used to specify the threshold value for the conditional formatting rule.

Percent

Indicates that a percent value is used to specify the threshold value for the conditional formatting rule.

Max

Indicates that the highest value in the range is used to specify the maximum threshold value for the conditional formatting rule.

Min

Indicates that the lowest value in the range is used to specify the minimum threshold value for the conditional formatting rule.

Formula

Indicates that a formula is used to specify the threshold value for the conditional formatting rule.

Percentile

Indicates that a percentile value is used to specify the threshold value for the conditional formatting rule.

AutoMin

For the data bar conditional formatting rule only. Indicates that the maximum threshold value is automatically set to zero or the maximum value in the range of cells, which ever is larger.

AutoMax

For the data bar conditional formatting rule only. Indicates that the minimum threshold value is automatically set to zero or the minimum value in the range of cells, whichever is smaller.

See Also