ConditionalStyleItem Class

In This Topic

Represents a condition that when matched by a Cell, applies the specified CellStyle to the Cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Class ConditionalStyleItem 
   Inherits GrapeCity.Spreadsheet.Win.SpreadConditionalCellStyleItem
   Implements FarPoint.Win.ISerializeSupport

'Usage
 
Dim instance As ConditionalStyleItem

public class ConditionalStyleItem : GrapeCity.Spreadsheet.Win.SpreadConditionalCellStyleItem, FarPoint.Win.ISerializeSupport

Remarks

Different ConditionalStyleOperators need different numbers of operands. If the ConditionalStyleOperator needs one operand, the Value1 is used as the only operand to compare to the cell value. If the ConditionalStyleOperator needs two operands, Value1 and Value2 are used together to compare to the cell value.

The following list lists the operators which do not need operands.

ConditionalStyleOperator.IsNull
ConditionalStyleOperator.IsNotNull
ConditionalStyleOperator.IsEmpty
ConditionalStyleOperator.IsNotEmpty
ConditionalStyleOperator.IsTrue
ConditionalStyleOperator.IsFalse

The following list lists the operators which need one operand.

ConditionalStyleOperator.Equals
ConditionalStyleOperator.NotEquals
ConditionalStyleOperator.GreaterThan
ConditionalStyleOperator.LessThan
ConditionalStyleOperator.GreaterThanOrEquals
ConditionalStyleOperator.LessThanOrEquals
ConditionalStyleOperator.Contains
ConditionalStyleOperator.StartsWith
ConditionalStyleOperator.EndsWith
ConditionalStyleOperator.IsMatch
ConditionalStyleOperator.IsNotMatch

The following list lists the operators which need two operands.

ConditionalStyleOperator.Between
ConditionalStyleOperator.NotBetween

Inheritance Hierarchy

System.Object
GrapeCity.Spreadsheet.Win.SpreadConditionalCellStyleItem
FarPoint.Win.Spread.ConditionalStyleItem

Reference

ConditionalStyleItem Members
FarPoint.Win.Spread Namespace
ConditionalStyleItemCollection Class
ConditionalStyleInfo Class