GemBox.Spreadsheet
  • Overview
  • Examples
  • Free version
  • Support
  • Pricelist

    Show / Hide Table of Contents

    ContainCondition Class

    Namespace:
    GemBox.Spreadsheet.ConditionalFormatting
    Assembly:
    GemBox.Spreadsheet.dll

    Represents a condition that formats only cells that contain value which satisfies the specified criteria.

    • C#
    • VB.NET
    public class ContainCondition : FormatCondition
    Public Class ContainCondition
        Inherits FormatCondition
    Inheritance:
    System.Object
    FormatCondition
    ContainCondition
    Derived
    ContainDateCondition
    ContainTextCondition
    ContainValueCondition

    Properties

    ConditionType

    Gets the Contain value.

    • C#
    • VB.NET
    public sealed override FormatConditionType ConditionType { get; }
    Public NotOverridable Overrides ReadOnly Property ConditionType As FormatConditionType
    Property Value
    FormatConditionType

    The Contain value.

    Overrides
    FormatCondition.ConditionType

    ContainConditionType

    Gets the ContainCondition type.

    • C#
    • VB.NET
    public ContainConditionType ContainConditionType { get; }
    Public ReadOnly Property ContainConditionType As ContainConditionType
    Property Value
    ContainConditionType

    The ContainCondition type.

    Style

    Gets the actual formatting which will be applied to a cell if its value satisfies this ContainCondition.

    • C#
    • VB.NET
    public CellStyle Style { get; }
    Public ReadOnly Property Style As CellStyle
    Property Value
    CellStyle

    The actual formatting which will be applied to a cell if its value satisfies this ContainCondition.

    Methods

    ToString()

    Returns a System.String that represents this ContainCondition instance.

    • C#
    • VB.NET
    public override string ToString()
    Public Overrides Function ToString As String
    Returns
    System.String

    A System.String that represents this ContainCondition instance.

    Overrides
    FormatCondition.ToString()
    Remarks

    This method should be used primarily for debugging purposes and should be considered volatile (format of its return value might change in future versions).

    Inherited Properties

    Rule

    Gets the conditional formatting rule associated with this condition.

    (Inherited from FormatCondition)

    Examples

    Excel Conditional Formatting example
    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.