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


The operator.
The text.
if set to true, the text parameter represents a formula; otherwise, it represents a normal text value.
true indicates that the expression, referred to by a custom name, will not be restricted; otherwise, false
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, _
   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);
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

See Also

Reference

TextConditionalFormattingRule Class
TextConditionalFormattingRule Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.