PowerTools SPREAD for ASP.NET 8.0J
Minimum プロパティ (DatabarConditionalFormattingRule)

最小値を取得または設定します。注意: 最小値は、そのTypeプロパティがMin、AutoMin、Number、Percent、Formula、PecentileのいずれかであるConditionalFormattingValueオブジェクトのみを受け入れます。
構文
'Declaration
 
Public Property Minimum As ConditionalFormattingValue
public ConditionalFormattingValue Minimum {get; set;}

プロパティ値

最小。
次のサンプルコードは、Minimumプロパティを使用します。
protected void Page_Load(object sender, EventArgs e)
{
    if (IsPostBack) return;
    FpSpread1.Sheets[0].RowCount = 4;
    FpSpread1.Sheets[0].Cells[0, 0].Value = 2;
    FpSpread1.Sheets[0].Cells[1, 0].Value = -1;
    FpSpread1.Sheets[0].Cells[3, 0].Value = 3;
    FarPoint.Web.Spread.DatabarConditionalFormattingRule dataBarRule = new FarPoint.Web.Spread.DatabarConditionalFormattingRule();
    dataBarRule.AxisPosition = FarPoint.Web.Spread.DataBarAxisPosition.Automatic;
    dataBarRule.BorderColor = System.Drawing.Color.Blue;
    dataBarRule.NegativeFillColor = System.Drawing.Color.Red;
    dataBarRule.Gradient = true;
    dataBarRule.Maximum = new FarPoint.Web.Spread.ConditionalFormattingValue(FarPoint.Web.Spread.ConditionalFormattingValueType.AutoMax);
    dataBarRule.Minimum = new FarPoint.Web.Spread.ConditionalFormattingValue(FarPoint.Web.Spread.ConditionalFormattingValueType.AutoMin);
    dataBarRule.UseNegativeFillColor = true;
    dataBarRule.UseNegativeBorderColor = false;

    FarPoint.Web.Spread.ConditionalFormatting cf = new FarPoint.Web.Spread.ConditionalFormatting(new FarPoint.Web.Spread.Model.CellRange(0, 0, 4, 1));
    cf.Add(dataBarRule);
    FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf);           
}
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load      
    If IsPostBack Then Return
    FpSpread1.Sheets(0).RowCount = 4
    FpSpread1.Sheets(0).Cells(0, 0).Value = 2
    FpSpread1.Sheets(0).Cells(1, 0).Value = -1
    FpSpread1.Sheets(0).Cells(3, 0).Value = 3
    Dim dataBarRule As New FarPoint.Web.Spread.DatabarConditionalFormattingRule()
    dataBarRule.AxisPosition = FarPoint.Web.Spread.DataBarAxisPosition.Automatic
    dataBarRule.BorderColor = Drawing.Color.Blue
    dataBarRule.NegativeFillColor = Drawing.Color.Red
    dataBarRule.Gradient = True
    dataBarRule.Maximum = New FarPoint.Web.Spread.ConditionalFormattingValue(FarPoint.Web.Spread.ConditionalFormattingValueType.AutoMax)
    dataBarRule.Minimum = New FarPoint.Web.Spread.ConditionalFormattingValue(FarPoint.Web.Spread.ConditionalFormattingValueType.AutoMin)
    dataBarRule.UseNegativeFillColor = True
    dataBarRule.UseNegativeBorderColor = False

    Dim cf As New FarPoint.Web.Spread.ConditionalFormatting(New FarPoint.Web.Spread.Model.CellRange(0, 0, 4, 1))
    cf.Add(dataBarRule)
    FpSpread1.ActiveSheetView.ConditionalFormatting.Add(cf)
End Sub
参照

DatabarConditionalFormattingRule クラス
DatabarConditionalFormattingRule メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.