TextConditionOperator Enumeration

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 uses the TextConditionOperator enumeration.

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

VB.NET

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

Inheritance Hierarchy

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

Reference

FarPoint.Web.Spread Namespace