Spread for ASP.NET 10 Product Documentation
ComparisonOperator Enumeration
Example Example 


Specifies the operator for conditional formats.
Syntax
'Declaration
 
Public Enum ComparisonOperator 
   Inherits System.Enum
'Usage
 
Dim instance As ComparisonOperator
public enum ComparisonOperator : System.Enum 
Members
MemberDescription
BetweenDetermines whether a cell value is between the two parameter values
EqualToDetermines whether a cell value is equal to the parameter value
GreaterThanDetermines whether a cell value is greater than the parameter value
GreaterThanOrEqualToDetermines whether a cell value is greater than or equal to the parameter value
IsEmptyDetermines whether a cell is empty
IsFalseDetermines whether a formula evaluates to false
IsTrueDetermines whether a formula evaluates to true
LessThanDetermines whether a cell value is less than the parameter value
LessThanOrEqualToDetermines whether a cell value is less than or equal to the parameter value
NotBetweenDetermines whether a cell value is not between the two parameter values
NotEqualToDetermines 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;
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

See Also

Reference

FarPoint.Web.Spread Namespace
ComparisonOperator Property

User-Task Documentation

Conditional Formatting of Cells

 

 


Copyright © GrapeCity, inc. All rights reserved.