FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > AverageConditionalFormattingRule クラス > AverageConditionalFormattingRule コンストラクタ : AverageConditionalFormattingRule コンストラクタ(Boolean,Boolean) |
true
に設定した場合、この条件付き書式ルールは平均より上の値を受け入れます。
true
に設定した場合、この条件付き書式ルールは平均と等しい値を受け入れます。
'Declaration Public Function New( _ ByVal isAbove As Boolean, _ ByVal isIncludedEquals As Boolean _ )
'使用法 Dim isAbove As Boolean Dim isIncludedEquals As Boolean Dim instance As New AverageConditionalFormattingRule(isAbove, isIncludedEquals)
public AverageConditionalFormattingRule( bool isAbove, bool isIncludedEquals )
true
に設定した場合、この条件付き書式ルールは平均より上の値を受け入れます。true
に設定した場合、この条件付き書式ルールは平均と等しい値を受け入れます。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); }
ttt tttttt tZtttttNt(tttttttt(tt tt tttGtFt(tt�;�O}8vXuA�}u�j�S�mů� ��-�o.B�xg2���ߘdm���Y�傍UA�7�T4=���tttttttZtttttNt(ttttttttTttttttTt\ttLtBt]t(ttttttttt tTtttttttTtt tttttTtMtZtDt(tttttttCt(tttt(tt��N}8vXuM�5u8*zF{kuS%5�> g��4��g2~ma��@�\�?�����I�Diٍ�ttttttttZtttttNt(ttttttttTtttttt(ttttttttt tTtttttttTtt tttttTtMtZtDt(tttttttCt(tttt(ttttt ttTttttttttt(ttBt@t(tt[s) ��w�