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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FarPoint.Web.Spread Namespace
ComparisonOperator Property

User-Task Documentation

Conditional Formatting of Cells