Sets conditional formatting for a specified range of cells on the sheet based on a specified comparison (and expression).
Syntax
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- style
- Style to be applied to the cell if the condition is satisfied
- op
- Comparison operator to apply to the cell value and the parameter values
- firstCondition
- Single condition expression
Example
This example applies a conditional format.
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(0, 0, 2, 2 styleCold, co.LessThan, one);
fpSpread1.ActiveSheet.SetConditionalFormat(0, 0, 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)
FpSpread1.ActiveSheet.SetConditionalFormat(0, 0, 2, 2, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, one)
FpSpread1.ActiveSheet.SetConditionalFormat(0, 0, 2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.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