Spread Windows Forms 6.0 Product Documentation
SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String) Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetStyleModel Class > SetConditionalFormat Method : SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

row: Row index of the cell in the model

column: Column index of the cell in the model

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

value: String with the specified value

Sets a conditional format for a cell in the model with the specified value.

Syntax

Visual Basic (Declaration)
Public Overloads Overridable Function SetConditionalFormat( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal style As NamedStyle, _ ByVal op As ComparisonOperator, _ ByVal value As String _ ) As Boolean

Visual Basic (Declaration)

Public Overloads Overridable Function SetConditionalFormat( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal style As NamedStyle, _
   ByVal op As ComparisonOperator, _
   ByVal value As String _
) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetStyleModel Dim row As Integer Dim column As Integer Dim style As NamedStyle Dim op As ComparisonOperator Dim value As String Dim value As Boolean value = instance.SetConditionalFormat(row, column, style, op, value)

Visual Basic (Usage)

Copy Code

Dim instance As DefaultSheetStyleModel
Dim row As Integer
Dim column As Integer
Dim style As NamedStyle
Dim op As ComparisonOperator
Dim value As String
Dim value As Boolean
 
value = instance.SetConditionalFormat(row, column, style, op, value)

C#
public virtual bool SetConditionalFormat( int row, int column, NamedStyle style, ComparisonOperator op, string value )

Parameters

row: Row index of the cell in the model
column: Column index of the cell in the model
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
value: String with the specified value

Return Value

Boolean: true if successful; false otherwise

Example

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.Model.DefaultSheetStyleModel ds; ds = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style; ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "20"); ds.SetConditionalFormat(2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.Between, one, two); fpSpread1.ActiveSheet.Cells[1, 1].Value = 10; fpSpread1.ActiveSheet.Cells[2, 2].Value = 32;

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.Model.DefaultSheetStyleModel ds;
ds = (FarPoint.Win.Spread.Model.DefaultSheetStyleModel)fpSpread1.ActiveSheet.Models.Style;
ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "20"); 
ds.SetConditionalFormat(2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.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 ds As FarPoint.Win.Spread.Model.DefaultSheetStyleModel ds = FpSpread1.ActiveSheet.Models.Style ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "20") ds.SetConditionalFormat(2, 2, styleCool, FarPoint.Win.Spread.ComparisonOperator.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 ds As FarPoint.Win.Spread.Model.DefaultSheetStyleModel
ds = FpSpread1.ActiveSheet.Models.Style
ds.SetConditionalFormat(1, 1, styleCold, FarPoint.Win.Spread.ComparisonOperator.LessThan, "20") 
ds.SetConditionalFormat(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

Syntax

Parameters

Return Value

Example

Requirements

See Also

Reference