Specifies the operator for conditional formats.

Syntax

Visual Basic (Declaration)
Public Enum ComparisonOperator Inherits System.Enum

Visual Basic (Usage)	Copy Code
Dim instance As ComparisonOperator

C#
public enum ComparisonOperator : System.Enum

Members

Member	Description
Between	Determines whether a cell value is between the two parameter values
EqualTo	Determines whether a cell value is equal to the parameter value
GreaterThan	Determines whether a cell value is greater than the parameter value
GreaterThanOrEqualTo	Determines whether a cell value is greater than or equal to the parameter value
IsEmpty	Determines whether a cell is empty
IsFalse	Determines whether a formula evaluates to false
IsTrue	Determines whether a formula evaluates to true
LessThan	Determines whether a cell value is less than the parameter value
LessThanOrEqualTo	Determines whether a cell value is less than or equal to the parameter value
NotBetween	Determines whether a cell value is not between the two parameter values
NotEqualTo	Determines whether a cell value is not equal to the parameter value

Example

This example uses the ComparisonOperator enumeration.

C#	Copy Code
FarPoint.Web.Spread.NamedStyle styleCold = new FarPoint.Web.Spread.NamedStyle(); FarPoint.Web.Spread.NamedStyle styleCool = new FarPoint.Web.Spread.NamedStyle(); styleCold.BackColor = Color.Blue; styleCool.BackColor = Color.Cyan; FarPoint.CalcEngine.Expression one; FarPoint.CalcEngine.Expression two; one = new FarPoint.CalcEngine.DoubleExpression(20.0); two = new FarPoint.CalcEngine.DoubleExpression(50.0); FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one); FpSpread1.ActiveSheetView.SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two); FpSpread1.ActiveSheetView.Cells(1, 1).Value = 10; FpSpread1.ActiveSheetView.Cells(2, 2).Value = 32;

Copy Code

FarPoint.Web.Spread.NamedStyle styleCold = new FarPoint.Web.Spread.NamedStyle();
FarPoint.Web.Spread.NamedStyle styleCool = new FarPoint.Web.Spread.NamedStyle();

styleCold.BackColor = Color.Blue;
styleCool.BackColor = Color.Cyan;

FarPoint.CalcEngine.Expression one;
FarPoint.CalcEngine.Expression two;
one = new FarPoint.CalcEngine.DoubleExpression(20.0);
two = new FarPoint.CalcEngine.DoubleExpression(50.0);


FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one);
FpSpread1.ActiveSheetView.SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two);

FpSpread1.ActiveSheetView.Cells(1, 1).Value = 10;
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 32;

VB.NET	Copy Code
Dim styleCold As New FarPoint.Web.Spread.NamedStyle Dim styleCool As New FarPoint.Web.Spread.NamedStyle styleCold.BackColor = Color.Blue styleCool.BackColor = Color.Cyan Dim one As FarPoint.CalcEngine.Expression Dim two As FarPoint.CalcEngine.Expression one = New FarPoint.CalcEngine.DoubleExpression(20.0) two = New FarPoint.CalcEngine.DoubleExpression(50.0) FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one) FpSpread1.ActiveSheetView.SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two) FpSpread1.ActiveSheetView.Cells(1, 1).Value = 10 FpSpread1.ActiveSheetView.Cells(2, 2).Value = 32

VB.NET

Copy Code

Dim styleCold As New FarPoint.Web.Spread.NamedStyle
Dim styleCool As New FarPoint.Web.Spread.NamedStyle

styleCold.BackColor = Color.Blue
styleCool.BackColor = Color.Cyan

Dim one As FarPoint.CalcEngine.Expression
Dim two As FarPoint.CalcEngine.Expression
one = New FarPoint.CalcEngine.DoubleExpression(20.0)
two = New FarPoint.CalcEngine.DoubleExpression(50.0)


FpSpread1.ActiveSheetView.SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one)
FpSpread1.ActiveSheetView.SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two)

FpSpread1.ActiveSheetView.Cells(1, 1).Value = 10
FpSpread1.ActiveSheetView.Cells(2, 2).Value = 32

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.ComparisonOperator

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Syntax

Members

Example

Inheritance Hierarchy

Requirements

See Also

Reference

User-Task Documentation

Spread for ASP.NET 7.0 Product Documentation
ComparisonOperator Enumeration
Example See Also Support Options