Visual Basic (Declaration) | |
---|---|
Public Overloads Function SetConditionalFormat( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal style As NamedStyle, _ ByVal op As ComparisonOperator, _ ByVal firstCondition As Expression, _ ByVal lastCondition As Expression _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim style As NamedStyle Dim op As ComparisonOperator Dim firstCondition As Expression Dim lastCondition As Expression Dim value As Boolean value = instance.SetConditionalFormat(row, column, style, op, firstCondition, lastCondition) |
C# | |
---|---|
public bool SetConditionalFormat( int row, int column, NamedStyle style, ComparisonOperator op, Expression firstCondition, Expression lastCondition ) |
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
- firstCondition
- First specified expression
- lastCondition
- First specified expression
Return Value
Boolean: true if successful; false otherwiseException | Description |
---|---|
System.ArgumentNullException | No condition is specified or specified condition is empty |
This example changes the color of the cell based on the value.
C# | Copy Code |
---|---|
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); FarPoint.Web.Spread.ComparisonOperator co = new FarPoint.Web.Spread.ComparisonOperator(); FpSpread1.Sheets[0].SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one); FpSpread1.Sheets[0].SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two); FpSpread1.Sheets[0].Cells[1, 1].Value = 10; FpSpread1.Sheets[0].Cells[2, 2].Value = 32; |
Visual Basic | Copy Code |
---|---|
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) Dim co As New FarPoint.Web.Spread.ComparisonOperator FpSpread1.Sheets(0).SetConditionalFormat(1, 1, styleCold, FarPoint.Web.Spread.ComparisonOperator.LessThan, one) FpSpread1.Sheets(0).SetConditionalFormat(2, 2, styleCool, FarPoint.Web.Spread.ComparisonOperator.Between, one, two) FpSpread1.Sheets(0).Cells(1, 1).Value = 10 FpSpread1.Sheets(0).Cells(2, 2).Value = 32 |
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family