ComparisonOperator Enumeration

Specifies the operator for conditional formats.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ComparisonOperator 
   Inherits System.Enum

'Usage
 
Dim instance As ComparisonOperator

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.

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

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

Reference

FarPoint.Web.Spread Namespace
ComparisonOperator Property

User-Task Documentation

Conditional Formatting of Cells