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

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

    Property Value

    The text condition.
    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