TextConditionOperator Enumeration | Spread Windows Forms 13.0 Product Documentation

TextConditionOperator Enumeration

In This Topic

Represents operators applied for text conditional formatting.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum TextConditionOperator 
   Inherits System.Enum

'Usage
 
Dim instance As TextConditionOperator

public enum TextConditionOperator : System.Enum

Members

Member	Description
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.

Example

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);
        }

VB.NET

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

System.Object
   System.ValueType
      System.Enum
         FarPoint.Win.Spread.TextConditionOperator

Reference

FarPoint.Win.Spread Namespace

Product Support Forum | Print this page