ConditionalFormattingIconValue コンストラクタ(Object,ConditionalFormattingValueType,Boolean,ConditionalFormattingIcon)

ConditionalFormattingIconValue クラスの新しいインスタンスを初期化します。

構文

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal value As Object, _
   ByVal type As ConditionalFormattingValueType, _
   ByVal isGreaterOrEquals As Boolean, _
   ByVal icon As ConditionalFormattingIcon _
)

'使用法
 
Dim value As Object
Dim type As ConditionalFormattingValueType
Dim isGreaterOrEquals As Boolean
Dim icon As ConditionalFormattingIcon
 
Dim instance As New ConditionalFormattingIconValue(value, type, isGreaterOrEquals, icon)

public ConditionalFormattingIconValue( 
   object value,
   ConditionalFormattingValueType type,
   bool isGreaterOrEquals,
   ConditionalFormattingIcon icon
)

パラメータ

value: 値。
type: タイプ。注意: ConditionalFormattingIconValueは、Number、Percent、Percentile、FormulaのいずれかのConditionalFormattingValueType値のみを受け入れます。
isGreaterOrEquals: 以上の場合はtrue。
icon: アイコン。

例

次のサンプルコードは、条件付き規則を作成します。

fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
fpSpread1.Sheets[0].Cells[0, 1].Value = 1;

FarPoint.Win.Spread.IconSetConditionalFormattingRule c = new FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom);
c.IconRuleSet.Add(new FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, true, FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle));
fpSpread1.Sheets[0].SetConditionalFormatting(1,1,c);

VB.NET

FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(0, 1).Value = 1
 
'IconSetConditionalFormatting
Dim c As New FarPoint.Win.Spread.IconSetConditionalFormattingRule(FarPoint.Win.Spread.ConditionalFormattingIconSetStyle.Custom)
c.IconRuleSet.Add(New FarPoint.Win.Spread.ConditionalFormattingIconValue(10, FarPoint.Win.Spread.ConditionalFormattingValueType.Number, True, FarPoint.Win.Spread.ConditionalFormattingIcon.BlackCircle))
FpSpread1.Sheets(0).SetConditionalFormatting(1, 1, c)

参照

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