PowerTools SPREAD for Windows Forms 8.0J
ConditionalFormattingIconValue コンストラクタ(Object,ConditionalFormattingValueType,Boolean,CustomImageInfo)


値。
タイプ。注意: ConditionalFormattingIconValueは、Number、Percent、Percentile、FormulaのいずれかのConditionalFormattingValueType値のみを受け入れます。
以上の場合はtrue
カスタム画像の情報
ConditionalFormattingIconValue クラスの新しいインスタンスを初期化します。
構文
'Declaration
 
Public Function New( _
   ByVal value As Object, _
   ByVal type As ConditionalFormattingValueType, _
   ByVal isGreaterOrEquals As Boolean, _
   ByVal customInfo As CustomImageInfo _
)
'使用法
 
Dim value As Object
Dim type As ConditionalFormattingValueType
Dim isGreaterOrEquals As Boolean
Dim customInfo As CustomImageInfo
 
Dim instance As New ConditionalFormattingIconValue(value, type, isGreaterOrEquals, customInfo)
public ConditionalFormattingIconValue( 
   object value,
   ConditionalFormattingValueType type,
   bool isGreaterOrEquals,
   CustomImageInfo customInfo
)

パラメータ

value
値。
type
タイプ。注意: ConditionalFormattingIconValueは、Number、Percent、Percentile、FormulaのいずれかのConditionalFormattingValueType値のみを受け入れます。
isGreaterOrEquals
以上の場合はtrue
customInfo
カスタム画像の情報
解説
isGreaterOrEqualsパラメーターをfalseに設定した場合、このパラメーターの意味は(「未満」ではなく)「より大きい」になります。カスタムアイコンを値の大きい順に指定してください。
次のサンプルコードは、ルールでカスタムアイコンを使用します。
System.Drawing.Icon resource1 = new System.Drawing.Icon("C:\\SpreadWin7\\SpWin7CSharp\\fpicon.ico");
System.Drawing.Icon resource2 = new System.Drawing.Icon("C:\\SpreadWin7\\SpWin7CSharp\\cat.ico");
fpSpread1.CustomIconContainer.AddIcon("fpicon", resource1);
fpSpread1.CustomIconContainer.AddIcon("cat", resource2);
FarPoint.Win.Spread.IconSetConditionalFormattingRule iconRule = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom);
iconRule.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(0, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, false, new FarPoint.Win.Spread.CustomImageInfo("fpicon")));
iconRule.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(1, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, false, new FarPoint.Win.Spread.CustomImageInfo("cat")));
fpSpread1_Sheet1.SetValue(0, 0, 0);
fpSpread1_Sheet1.SetValue(1, 0, 1);
fpSpread1_Sheet1.SetValue(2, 0, 2);
fpSpread1_Sheet1.SetConditionalFormatting(0, 0, 3, 1, new FarPoint.Win.Spread.IConditionalFormattingRule[] { iconRule });
Dim resource1 As New System.Drawing.Icon("C:\SpreadWin7\SpWin7CSharp\fpicon.ico")
Dim resource2 As New System.Drawing.Icon("C:\SpreadWin7\SpWin7CSharp\cat.ico")
FpSpread1.CustomIconContainer.AddIcon("fpicon", resource1)
FpSpread1.CustomIconContainer.AddIcon("cat", resource2)
Dim iconRule As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom)
iconRule.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(0, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, False, New FarPoint.Win.Spread.CustomImageInfo("fpicon")))
iconRule.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(1, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, False, New FarPoint.Win.Spread.CustomImageInfo("cat")))
FpSpread1_Sheet1.SetValue(0, 0, 0)
FpSpread1_Sheet1.SetValue(1, 0, 1)
FpSpread1_Sheet1.SetValue(2, 0, 2)
FpSpread1_Sheet1.SetConditionalFormatting(0, 0, 3, 1, New FarPoint.Win.Spread.IConditionalFormattingRule() {iconRule})
参照

ConditionalFormattingIconValue クラス
ConditionalFormattingIconValue メンバ
オーバーロード一覧

 

 


© 2004-2015, GrapeCity inc. All rights reserved.