Spread Windows Forms 9.0 Product Documentation
TextConditionalFormattingRule Constructor(TextConditionOperator,String,Boolean)
Example 


The operator.
The text.
if set to true, the text parameter represents a formula; otherwise, it represents a normal text value.
Initializes a new instance of the TextConditionalFormattingRule class.
Syntax
'Declaration
 
Public Function New( _
   ByVal op As TextConditionOperator, _
   ByVal text As String, _
   ByVal isFormula As Boolean _
)
'Usage
 
Dim op As TextConditionOperator
Dim text As String
Dim isFormula As Boolean
 
Dim instance As New TextConditionalFormattingRule(op, text, isFormula)
public TextConditionalFormattingRule( 
   TextConditionOperator op,
   string text,
   bool isFormula
)

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.
Example
This example creates a text rule.
FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", true);
// Cell (1,1) must contain the text you type in C1            
text.BackColor = Color.Red;
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);
Dim Text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", True)
' 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

See Also

Reference

TextConditionalFormattingRule Class
TextConditionalFormattingRule Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.