UniqueOrDuplicateCondition Class

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

Represents a condition that formats only cells with unique or duplicate values.

public sealed class UniqueOrDuplicateCondition : FormatCondition
Public NotInheritable Class UniqueOrDuplicateCondition
    Inherits FormatCondition
Inheritance:
System.Object
UniqueOrDuplicateCondition

Properties

ConditionType

Gets the UniqueOrDuplicate value.

public override FormatConditionType ConditionType { get; }
Public Overrides ReadOnly Property ConditionType As FormatConditionType
Property Value
FormatConditionType
Overrides

Duplicate

Gets or sets a value indicating whether to format cells with duplicate values.

Default value is false (formats cells with unique values).

public bool Duplicate { get; set; }
Public Property Duplicate As Boolean
Property Value
System.Boolean

true to format cells with duplicate values; otherwise, false.

Style

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

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 UniqueOrDuplicateCondition.

Methods

ToString()

Returns a System.String that represents this UniqueOrDuplicateCondition instance.

public override string ToString()
Public Overrides Function ToString As String
Returns
System.String

A System.String that represents this UniqueOrDuplicateCondition instance.

Overrides
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