Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / UnaryComparisonConditionalFormattingRule Class / Operator Property
Example


In This Topic
    Operator Property (UnaryComparisonConditionalFormattingRule)
    In This Topic
    Gets or sets the operator.
    Syntax
    'Declaration
     
    Public Property Operator As UnaryComparisonOperator
    'Usage
     
    Dim instance As UnaryComparisonConditionalFormattingRule
    Dim value As UnaryComparisonOperator
     
    instance.Operator = value
     
    value = instance.Operator
    public UnaryComparisonOperator Operator {get; set;}

    Property Value

    The operator.
    Example
    This example sets the Operator property.
    protected void Page_Load(object sender, System.EventArgs e)
                           {
                               FpSpread1.Sheets[0].Cells[0, 0].Value = 3;
                               FpSpread1.Sheets[0].Cells[1, 0].Value = 2;
                               FpSpread1.Sheets[0].Cells[1, 1].Value = 10;
                               FpSpread1.Sheets[0].Cells[0, 2].Value = 1;    
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                //Unary comparison CF
                FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule unary = new FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10);
                unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo;
                unary.Value = 10;
                unary.BackColor = Color.Red;
                unary.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
                unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary);   
            }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
                FpSpread1.Sheets(0).Cells(0, 0).Value = 3
                FpSpread1.Sheets(0).Cells(1, 0).Value = 2
                FpSpread1.Sheets(0).Cells(1, 1).Value = 10
                FpSpread1.Sheets(0).Cells(0, 2).Value = 1
            End Sub
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                'Unary comparison CF
                Dim unary As New FarPoint.Web.Spread.UnaryComparisonConditionalFormattingRule(FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo, 10)
                unary.Operator = FarPoint.Web.Spread.UnaryComparisonOperator.EqualTo
                unary.Value = 10
                unary.BackColor = Drawing.Color.Red
                unary.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
                unary.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, unary)
            End Sub
    See Also