PowerTools SPREAD for Windows Forms 10.0J
StandardDeviation プロパティ (AverageConditionalFormattingRule)


標準偏差を取得または設定します。
構文
'Declaration
 
Public Property StandardDeviation As Integer
'使用法
 
Dim instance As AverageConditionalFormattingRule
Dim value As Integer
 
instance.StandardDeviation = value
 
value = instance.StandardDeviation
public int StandardDeviation {get; set;}

プロパティ値

標準偏差。
次のサンプルコードは、条件付き規則を作成します。
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);
        }
ttttttttttZtttttNt(tttttttt(tt
tttttGtFt(tt�;�O}8vXuA�}u�j�S�mů�    ��-�o.B�xg2���ߘdm���Y�傍UA�7�T4=���tttttttZtttttNt(ttttttttTttttttTt\ttLtBt]t(ttttttttttTtttttttTtttttttTtMtZtDt(tttttttCt(tttt(tt��N}8vXuM�5u8*΂zF{kuS%5�>
g��4��g2~ma��@�\�?�����I�Diٍ�ttttttttZtttttNt(ttttttttTtttttt(ttttttttttTtttttttTtttttttTtMtZtDt(tttttttCt(tttt(tttttttTttttttttt(ttBt@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 メンバ

 

 


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