IsIncludeEquals プロパティ

この条件付き書式ルールが平均と等しい値を受け入れるかどうかを示す値を取得または設定します。

構文

Visual Basic
C#

'Declaration
 
Public Property IsIncludeEquals As Boolean

'使用法
 
Dim instance As AverageConditionalFormattingRule
Dim value As Boolean
 
instance.IsIncludeEquals = value
 
value = instance.IsIncludeEquals

public bool IsIncludeEquals {get; set;}

プロパティ値

このインスタンスが平均と等しい値を受け入れる場合は true。それ以外の場合は false。

例

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

private void Form1_Load(object sender, EventArgs e)
        {
            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, 2].Value = 1;            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //Average CF
            FarPoint.Win.Spread.AverageConditionalFormattingRule average = new FarPoint.Win.Spread.AverageConditionalFormattingRule(true, true);
            average.IsAbove = true;
            average.IsIncludeEquals = true;
            average.StandardDeviation = 2;
            average.FontStyle = new FarPoint.Win.Spread.SpreadFontStyle(RegularBoldItalicFontStyle.Bold);
            fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, average);
        }

VB.NET

ttttttttttZtttttNt(tttttttt(tt
tttttGtFt(tt�;�O}8vXuA�}u�j�S�mů�    ��-�o.B�xg2���ߘdm���Y�傍UA�7�T4=���tttttttZtttttNt(ttttttttTttttttTt\ttLtBt]t(ttttttttttTtttttttTtttttttTtMtZtDt(tttttttCt(tttt(tt��N}8vXuM�5u8*΂zF{kuS%5�>
g��4��g2~ma��@�\�?�����I�Diٍ�ttttttttZtttttNt(ttttttttTtttttt(ttttttttttTtttttttTtttttttTtMtZtDt(tttttttCt(tttt(tttttttTttttttttt(ttBt@t(tt[s)��w�<>#
O    O\o@      �oou<ooGoonqooohooonooooooooooomoooooooooooooooooooooooooooooooooof�oB�Ojoookl�oooo}l�l�l�l�oooooooooooooooooooooooooooooooooooooo�nhNzzn�Boo
oo
o?o*o?o*om,o=o*o.o;o*oOo;o.o-o#o*oOo?o*oGo<o'o.o]oOo-o#o o-oOo!o o;oOo!o:o#o#oOo,o o!o<o;o=o.o&o!o;oOo?o$o0o?o*oOo?o=o&o"

参照

AverageConditionalFormattingRule クラス
 AverageConditionalFormattingRule メンバ