GrapeCity SPREAD for Windows Forms 11.0J
Formula プロパティ (TextConditionalFormattingRule)


数式を取得または設定します。
構文
'Declaration
 
Public Property Formula As String
'使用法
 
Dim instance As TextConditionalFormattingRule
Dim value As String
 
instance.Formula = value
 
value = instance.Formula
public string Formula {get; set;}

プロパティ値

数式。
次のサンプルコードは、Formulaプロパティを設定します。
FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "aaa");
// Cell (1,1) must contain the text you type in C1
text.Formula = "=C1";
text.BackColor = Color.Red;
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);
Dim Text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "aaa")
' Cell (1,1) must contain the text you type in C1
Text.Formula = "=C1"
Text.BackColor = Color.Red
FpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, Text)
参照

TextConditionalFormattingRule クラス
TextConditionalFormattingRule メンバ

 

 


© 2004-2018, GrapeCity Inc. All rights reserved.