IsAbove プロパティ

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

構文

Visual Basic
C#

'Declaration
 
Public Property IsAbove As Boolean

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

public bool IsAbove {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 メンバ