Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetStyleModel Class / SetConditionalFormat Method / SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String,String) Method
Row index of the cell in the model
Column index of the cell in the model
Style to be applied to the cell if the condition is satisfied
Comparison operator to apply to the cell value and the parameter values
First specified value
Last specified value


In This Topic
    SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,String,String) Method
    In This Topic
    Sets a conditional format for a cell in the model with the specified values.
    Syntax
    'Declaration
     
    
    Public Overloads Overridable Function SetConditionalFormat( _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal style As NamedStyle, _
       ByVal op As ComparisonOperator, _
       ByVal firstCondition As String, _
       ByVal lastCondition As String _
    ) As Boolean
    'Usage
     
    
    Dim instance As DefaultSheetStyleModel
    Dim row As Integer
    Dim column As Integer
    Dim style As NamedStyle
    Dim op As ComparisonOperator
    Dim firstCondition As String
    Dim lastCondition As String
    Dim value As Boolean
     
    value = instance.SetConditionalFormat(row, column, style, op, firstCondition, lastCondition)

    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 parameter values
    firstCondition
    First specified value
    lastCondition
    Last specified value

    Return Value

    Boolean: true if successful; false otherwise
    Exceptions
    ExceptionDescription
    No condition is specified or specified condition is empty
    Specified condition is not valid; must be a string
    See Also