Search Results for

    Show / Hide Table of Contents

    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 <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
    ☀
    ☾
    Downloads
    • Download with Nuget
    • Start for Free
    In This Article
    Back to top
    Install with Nuget
    Want to deploy IronXL to a live project for FREE?
    What’s included?
    30 days of fully-functional product
    Test and share in a live environment
    No watermarks in production
    Get your free 30-day Trial Key instantly.
    No credit card or account creation required
    Your Trial License Key has been emailed to you.
    Download IronXL free to apply
    your Trial Licenses Key
    Install with NuGet View Licenses
    Licenses from $499. Have a question? Get in touch.