FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > TextConditionalFormattingRule クラス > TextConditionalFormattingRule コンストラクタ : TextConditionalFormattingRule コンストラクタ(TextConditionOperator,String,Boolean) |
true
に設定した場合、テキストパラメーターは数式を表します。それ以外の場合は、通常のテキスト値を表します。
'Declaration
Public Function New( _ ByVal op As TextConditionOperator, _ ByVal text As String, _ ByVal isFormula As Boolean _ )
'使用法
Dim op As TextConditionOperator Dim text As String Dim isFormula As Boolean Dim instance As New TextConditionalFormattingRule(op, text, isFormula)
true
に設定した場合、テキストパラメーターは数式を表します。それ以外の場合は、通常のテキスト値を表します。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)