Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / TextConditionalFormattingRule Class / Operator Property
Example


In This Topic
    Operator Property (TextConditionalFormattingRule)
    In This Topic
    Gets or sets conditions used for checking text.
    Syntax
    'Declaration
     
    Public Property Operator As TextConditionOperator
    'Usage
     
    Dim instance As TextConditionalFormattingRule
    Dim value As TextConditionOperator
     
    instance.Operator = value
     
    value = instance.Operator
    public TextConditionOperator Operator {get; set;}

    Property Value

    The text condition.
    Example
    This example sets the Operator property.
    protected void Page_Load(object sender, System.EventArgs e)
                           {
                               FpSpread1.Sheets[0].Cells[1, 1].Text = "aaatest";
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                //TextContains CF
                FarPoint.Web.Spread.TextConditionalFormattingRule text = new FarPoint.Web.Spread.TextConditionalFormattingRule(FarPoint.Web.Spread.TextConditionOperator.BeginsWith, "aaa");
                text.Operator = FarPoint.Web.Spread.TextConditionOperator.BeginsWith;
                text.BackColor = Color.Red;
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, text);
            }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
                FpSpread1.Sheets(0).Cells(1, 1).Text = "aaatest"
            End Sub
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                'TextContains CF
                Dim text As New FarPoint.Web.Spread.TextConditionalFormattingRule(FarPoint.Web.Spread.TextConditionOperator.BeginsWith, "aaa")
                text.Operator = FarPoint.Web.Spread.TextConditionOperator.BeginsWith
                text.BackColor = Drawing.Color.Red
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, text)
            End Sub
    See Also