Class ConditionType
Represents a type of a conditional formatting rule
Inheritance
Namespace: IronXL.Formatting
Assembly: IronXL.dll
Syntax
public class ConditionType : Object
Fields
CellValueIs
This conditional formatting rule compares a cell value to a formula calculated result, using an operator
Declaration
public static ConditionType CellValueIs
Field Value
Type | Description |
---|---|
ConditionType |
ColorScale
Declaration
public static ConditionType ColorScale
Field Value
Type | Description |
---|---|
ConditionType |
DataBar
This conditional formatting rule sets a data bar, with the cell populated with bars based on their values
Declaration
public static ConditionType DataBar
Field Value
Type | Description |
---|---|
ConditionType |
Filter
This conditional formatting rule that files the values
Declaration
public static ConditionType Filter
Field Value
Type | Description |
---|---|
ConditionType |
Formula
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
Declaration
public static ConditionType Formula
Field Value
Type | Description |
---|---|
ConditionType |
IconSet
This conditional formatting rule sets a data bar, with the cell populated with bars based on their values
Declaration
public static ConditionType IconSet
Field Value
Type | Description |
---|---|
ConditionType |
Properties
Id
Type's numeric id
Declaration
public byte Id { get; set; }
Property Value
Type | Description |
---|---|
System.Byte |
Type
Internal condition type name
Declaration
public string Type { get; set; }
Property Value
Type | Description |
---|---|
System.String |
Methods
Equals(Object)
Determines whether the specified object is equal to the current ConditionType.
Declaration
public override bool Equals(object obj)
Parameters
Type | Name | Description |
---|---|---|
System.Object | obj | The object to compare with the current ConditionType. |
Returns
Type | Description |
---|---|
System.Boolean | true if the specified object is equal to the current object; otherwise, false. |
ForId(Byte)
Get ConditionType for specified id
Declaration
public static ConditionType ForId(byte id)
Parameters
Type | Name | Description |
---|---|---|
System.Byte | id | ConditionType id |
Returns
Type | Description |
---|---|
ConditionType | ConditionType that corresponds to specified id |
ForId(Int32)
Get ConditionType for specified id
Declaration
public static ConditionType ForId(int id)
Parameters
Type | Name | Description |
---|---|---|
System.Int32 | id | ConditionType id |
Returns
Type | Description |
---|---|
ConditionType | ConditionType that corresponds to specified id |
GetHashCode()
Hash function
Declaration
public override int GetHashCode()
Returns
Type | Description |
---|---|
System.Int32 | Hash code for current ConditionType |
ToString()
Represents ConditionType in a string format
Declaration
public override string ToString()
Returns
Type | Description |
---|---|
System.String |
Operators
Explicit(ConditionType to <7cd1fa6a-9b17-4496-a7e5-225077b3c156>ConditionType)
Declaration
public static explicit operator < 7 cd1fa6a - 9 b17 - 4496 - a7e5 - 225077 b3c156 > ConditionType(ConditionType obj)
Parameters
Type | Name | Description |
---|---|---|
ConditionType | obj |
Returns
Type | Description |
---|---|
NPOI.SS.UserModel.<7cd1fa6a-9b17-4496-a7e5-225077b3c156>ConditionType |
Explicit(<7cd1fa6a-9b17-4496-a7e5-225077b3c156>ConditionType to ConditionType)
Declaration
public static explicit operator ConditionType( < 7 cd1fa6a - 9 b17 - 4496 - a7e5 - 225077 b3c156 > ConditionType obj)
Parameters
Type | Name | Description |
---|---|---|
NPOI.SS.UserModel.<7cd1fa6a-9b17-4496-a7e5-225077b3c156>ConditionType | obj |
Returns
Type | Description |
---|---|
ConditionType |