FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat

SetConditionalFormat Method

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string)

Sets a parameterized conditional format for the cell at the specified row and column.

Declaration

bool SetConditionalFormat(int row, int column, NamedStyle style, ComparisonOperator op, string value)

Function SetConditionalFormat(row As Integer, column As Integer, style As NamedStyle, op As ComparisonOperator, value As String) As Boolean

Parameters

Type	Name	Description
int	row	Row index of cell
int	column	Column index of cell
NamedStyle	style	Style to be applied to the cell if the condition is satisfied
ComparisonOperator	op	Comparison operator to apply to the cell value and the parameter value
string	value	Parameter value

Returns

Type	Description
bool

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string, string)

Sets a parameterized conditional format for the cell at the specified row and column.

Declaration

bool SetConditionalFormat(int row, int column, NamedStyle style, ComparisonOperator op, string firstCondition, string lastCondition)

Function SetConditionalFormat(row As Integer, column As Integer, style As NamedStyle, op As ComparisonOperator, firstCondition As String, lastCondition As String) As Boolean

Parameters

Type	Name	Description
int	row	Row index of cell
int	column	Column index of cell
NamedStyle	style	Style to be applied to the cell if the condition is satisfied
ComparisonOperator	op	Comparison operator to apply to the cell value and the parameter values
string	firstCondition	First parameter value
string	lastCondition	Last parameter value

Returns

Type	Description
bool

SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, Expression, Expression)

Sets a parameterized conditional format for the cell at the specified row and column.

Declaration

bool SetConditionalFormat(int row, int column, NamedStyle style, ComparisonOperator op, Expression firstCondition, Expression lastCondition)

Function SetConditionalFormat(row As Integer, column As Integer, style As NamedStyle, op As ComparisonOperator, firstCondition As Expression, lastCondition As Expression) As Boolean

Parameters

Type	Name	Description
int	row	Row index of cell
int	column	Column index of cell
NamedStyle	style	Style to be applied to the cell if the condition is satisfied
ComparisonOperator	op	Comparison operator to apply to the cell value and the parameter values
Expression	firstCondition	First parameter value
Expression	lastCondition	Last parameter value

Returns

Type	Description
bool

SetConditionalFormat Method