FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : ComparisonOperator Enumeration |
'Declaration Public Enum ComparisonOperator Inherits System.Enum
'Usage Dim instance As ComparisonOperator
public enum ComparisonOperator : System.Enum
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 |
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
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.ComparisonOperator
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