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

    Show / Hide Table of Contents

    ConditionalIcon Class

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

    Represents a conditional icon used in IconSetCondition of a conditional formatting rule to specify icon and a lower bound of the values onto which the icon is applied.

    • C#
    • VB.NET
    public sealed class ConditionalIcon : ConditionalObject
    Public NotInheritable Class ConditionalIcon
        Inherits ConditionalObject
    Inheritance:
    System.Object
    ConditionalObject
    ConditionalIcon

    Properties

    Equal

    Gets or sets a value indicating whether this or next icon will be shown if cell's value is equal to this Value.

    Default value is true (this icon will be shown if cell's value is equal to this Value).

    • C#
    • VB.NET
    public bool Equal { get; set; }
    Public Property Equal As Boolean
    Property Value
    System.Boolean

    true if this icon will be shown if cell's value is equal to this Value; otherwise, false.

    Icon

    Gets or sets the icon.

    • C#
    • VB.NET
    public SpreadsheetIcon Icon { get; set; }
    Public Property Icon As SpreadsheetIcon
    Property Value
    SpreadsheetIcon

    The icon.

    Methods

    ToString()

    Returns a System.String that represents this ConditionalIcon instance.

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

    A System.String that represents this ConditionalIcon instance.

    Overrides
    ConditionalObject.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

    Value

    Gets or sets the value.

    (Inherited from ConditionalObject)

    Examples

    Excel Conditional Formatting example
    Back to top

    Facebook • Twitter • LinkedIn

    © GemBox Ltd. — All rights reserved.