MESCIUS SPREAD for ASP.NET 10.0J
TwoColorScaleConditionalFormattingRule コンストラクタ(Color,Color)

最小値の色。
最大値の色。
TwoColorScaleConditionalFormattingRuleクラスの新しいインスタンスを初期化します。
構文
'Declaration
 
Public Function New( _
   ByVal minColor As Color, _
   ByVal maxColor As Color _
)
public TwoColorScaleConditionalFormattingRule( 
   Color minColor,
   Color maxColor
)

パラメータ

minColor
最小値の色。
maxColor
最大値の色。
次のサンプルコードは、2色スケールのルールを作成します。
protected void Page_Load(object sender, EventArgs e)
{
    if (this.IsPostBack) return;
    
    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;
    FarPoint.Web.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Web.Spread.TwoColorScaleConditionalFormattingRule(System.Drawing.Color.Red, System.Drawing.Color.Blue);
    FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 2, 2, two);
}
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    If IsPostBack Then
        Return
    End If

    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
    Dim two As New FarPoint.Web.Spread.TwoColorScaleConditionalFormattingRule(System.Drawing.Color.Red, System.Drawing.Color.Blue)
    FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 2, 2, two)
End Sub
参照

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

 

 


© MESCIUS inc. All rights reserved.