Spread ASP.NET 17
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / DefaultSheetStyleModel Class / SetConditionalFormat Method / SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) 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 specified value
First specified expression
Last specified expression


In This Topic
    SetConditionalFormat(Int32,Int32,NamedStyle,ComparisonOperator,Expression,Expression) Method
    In This Topic
    Sets a conditional format for a cell in the model with the specified expressions.
    Syntax
    '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
    'Usage
     
    
    Dim instance As DefaultSheetStyleModel
    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)

    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
    firstCondition
    First specified expression
    lastCondition
    Last specified expression

    Return Value

    Boolean: true if successful; false otherwise
    Exceptions
    ExceptionDescription
    No condition is specified or specified condition is empty
    See Also