Back to Devexpress

XlCondFmtValueObjectType Enum

corelibraries-devexpress-dot-export-dot-xl-39924efa.md

latest2.2 KB
Original Source

XlCondFmtValueObjectType Enum

Lists values the specify the type of the threshold value to be used in conditional formatting rules

Namespace : DevExpress.Export.Xl

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

NuGet Package : DevExpress.Printing.Core

Declaration

csharp
public enum XlCondFmtValueObjectType
vb
Public Enum XlCondFmtValueObjectType

Members

NameDescription
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.

|

The following properties accept/return XlCondFmtValueObjectType values:

See Also

DevExpress.Export.Xl Namespace