Sets conditional formatting for a specified cell on the sheet based on a specified expression.
Syntax
Parameters
- row
- Row index of the cell
- column
- Column index of the cell
- style
- Style to be applied to the cell if the condition is satisfied
- op
- Comparison operator to apply to the cell value and the specified value
- condition
- Single condition expression
Return Value
Boolean:
true if successful;
false otherwise
Exceptions
Example
This example changes the color of the cell based on the value in the cell.
C# | Copy Code |
---|
FarPoint.Win.Spread.NamedStyle styleCold = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle styleCool = new FarPoint.Win.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);
FarPoint.Win.Spread.ComparisonOperator co = new FarPoint.Win.Spread.ComparisonOperator();
fpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, co.LessThan, one);
fpSpread1.ActiveSheet.SetConditionalFormat(2, 2, styleCool, co.Between, one, two);
fpSpread1.ActiveSheet.Cells(1, 1).Value = 10;
fpSpread1.ActiveSheet.Cells(2, 2).Value = 32; |
Visual Basic | Copy Code |
---|
Dim styleCold As New FarPoint.Win.Spread.NamedStyle
Dim styleCool As New FarPoint.Win.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)
Dim co As New FarPoint.Win.Spread.ComparisonOperator
FpSpread1.ActiveSheet.SetConditionalFormat(1, 1, styleCold, co.LessThan, one)
FpSpread1.ActiveSheet.SetConditionalFormat(2, 2, styleCool, co.Between, one, two)
FpSpread1.ActiveSheet.Cells(1, 1).Value = 10
FpSpread1.ActiveSheet.Cells(2, 2).Value = 32 |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also