Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / TextConditionOperator Enumeration
Example Example

In This Topic
    TextConditionOperator Enumeration
    In This Topic
    Represents operators applied for text conditional formatting.
    Public Enum TextConditionOperator 
       Inherits System.Enum
    Dim instance As TextConditionOperator
    public enum TextConditionOperator : System.Enum 
    BeginsWith The value contains the specified text at the beginning.
    Contains The value contains the specified text.
    EndsWith The value contains the specified text at the end.
    NotContains The value does not contain the specified text.
    This example creates a conditional rule.
    private void Form1_Load(object sender, EventArgs e)
                fpSpread1.Sheets[0].Cells[1, 1].Text = "aaatest";
            private void button1_Click(object sender, EventArgs e)
                //TextContains CF
                FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.BeginsWith, "aaa");
                text.Operator = FarPoint.Win.Spread.TextConditionOperator.BeginsWith;
                text.BackColor = Color.Red;
                fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            FpSpread1.Sheets(0).Cells(1, 1).Text = "aaatest"
        End Sub
        Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            'TextContains CF
            Dim text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.BeginsWith, "aaa")
            text.Operator = FarPoint.Win.Spread.TextConditionOperator.BeginsWith
            text.BackColor = Color.Red
            FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text)
        End Sub
    Inheritance Hierarchy


    See Also