ConditionalStyleItem Class

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

Inheritance

object

ConditionalStyleItem

Implements

ICloneable

ISerializable

ISerializeSupport

Namespace: FarPoint.Win.Spread

Assembly: FarPoint.Win.Spread.dll

Syntax

[TypeConverter(typeof(_abz))]
public class ConditionalStyleItem : SpreadConditionalCellStyleItem, ICloneable, ISerializable, ISerializeSupport

<TypeConverter(GetType(_abz))>
Public Class ConditionalStyleItem
    Inherits SpreadConditionalCellStyleItem
    Implements ICloneable, ISerializable, 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

Constructors

Name	Description
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator, bool)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator, object)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator, object, bool)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator, object, object)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(AppearanceStyleInfo, ConditionalStyleOperator, object, object, bool)	Initializes a new instance of the ConditionalStyleItem class.
ConditionalStyleItem(SerializationInfo, StreamingContext)	Initializes a new instance of this class.

Properties

Name	Description
CellStyle	Gets or sets a CellStyle that is applied to the Cell when the condition matches.
IgnoreCase	Gets or sets a value that indicates whether the item to match is case insensitive.
Operator	Gets or sets a value that the Value should match.
Value1	Gets or sets a value that indicates the first operation value when the operator needs several arguments.
Value2	Gets or sets a value that indicates the second operation value when the operator needs several arguments.

Methods

Name	Description
Clone()	Creates an exact copy of the current ConditionalStyleItem.
Deserialize(XmlNodeReader)	Loads the object from XML.
GetObjectData(SerializationInfo, StreamingContext)	Gets the object data.
Serialize(XmlTextWriter)	Saves the object to XML.