Class ConditionType
Represents a type of a conditional formatting rule
Inheritance
Namespace: IronXL.Formatting
Assembly: IronXL.dll
Syntax
public class ConditionType : ObjectFields
CellValueIs
This conditional formatting rule compares a cell value to a formula calculated result, using an operator
Declaration
public static ConditionType CellValueIsField Value
| Type | Description |
|---|---|
| ConditionType |
ColorScale
Declaration
public static ConditionType ColorScaleField 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 DataBarField Value
| Type | Description |
|---|---|
| ConditionType |
Filter
This conditional formatting rule that files the values
Declaration
public static ConditionType FilterField 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 FormulaField 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 IconSetField 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 <fd84aa99-bbf6-482a-9e07-31dc614897a0>ConditionType)
Declaration
public static explicit operator < fd84aa99 - bbf6 - 482 a - 9e07 - 31d c614897a0 > ConditionType(ConditionType obj)Parameters
| Type | Name | Description |
|---|---|---|
| ConditionType | obj |
Returns
| Type | Description |
|---|---|
| NPOI.SS.UserModel.<fd84aa99-bbf6-482a-9e07-31dc614897a0>ConditionType |
Explicit(<fd84aa99-bbf6-482a-9e07-31dc614897a0>ConditionType to ConditionType)
Declaration
public static explicit operator ConditionType( < fd84aa99 - bbf6 - 482 a - 9e07 - 31d c614897a0 > ConditionType obj)Parameters
| Type | Name | Description |
|---|---|---|
| NPOI.SS.UserModel.<fd84aa99-bbf6-482a-9e07-31dc614897a0>ConditionType | obj |
Returns
| Type | Description |
|---|---|
| ConditionType |