Class ConditionType

Represents a type of a conditional formatting rule

Inheritance
System.Object
ConditionType
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 <6b07f4d0-5621-4b03-958b-57fc97ec4822>ConditionType)

Declaration
public static explicit operator  < 6  b07f4d0 - 5621 - 4  b03 - 958  b - 57f  c97ec4822 > ConditionType(ConditionType obj)
Parameters
Type Name Description
ConditionType obj
Returns
Type Description
NPOI.SS.UserModel.<6b07f4d0-5621-4b03-958b-57fc97ec4822>ConditionType

Explicit(<6b07f4d0-5621-4b03-958b-57fc97ec4822>ConditionType to ConditionType)

Declaration
public static explicit operator ConditionType( < 6  b07f4d0 - 5621 - 4  b03 - 958  b - 57f  c97ec4822 > ConditionType obj)
Parameters
Type Name Description
NPOI.SS.UserModel.<6b07f4d0-5621-4b03-958b-57fc97ec4822>ConditionType obj
Returns
Type Description
ConditionType