TextConditionalFormattingRule Constructor(TextConditionOperator,String,Boolean,Boolean)

Initializes a new instance of the TextConditionalFormattingRule class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal op As TextConditionOperator, _
   ByVal text As String, _
   ByVal isFormula As Boolean, _
   ByVal suppressCustomName As Boolean _
)

'Usage
 
Dim op As TextConditionOperator
Dim text As String
Dim isFormula As Boolean
Dim suppressCustomName As Boolean
 
Dim instance As New TextConditionalFormattingRule(op, text, isFormula, suppressCustomName)

public TextConditionalFormattingRule( 
   TextConditionOperator op,
   string text,
   bool isFormula,
   bool suppressCustomName
)

Parameters

op: The operator.
text: The text.
isFormula: if set to true, the text parameter represents a formula; otherwise, it represents a normal text value.
suppressCustomName: true indicates that the expression, referred to by a custom name, will not be restricted; otherwise, false

Example

This example creates a text rule.

FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", true, false);
// Cell (1,1) must contain the text you type in C1            
text.BackColor = Color.Red;
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);

Visual Basic

Dim Text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", True, False)
' Cell (1,1) must contain the text you type in C1            
Text.BackColor = Color.Red
FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, Text)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

TextConditionalFormattingRule Class
TextConditionalFormattingRule Members
Overload List