DataBarAxisPosition 列挙体

データバーの軸位置を表します。

構文

Visual Basic
C#

'Declaration
 
Public Enum DataBarAxisPosition 
   Inherits System.Enum

public enum DataBarAxisPosition : System.Enum

メンバ

メンバ	説明
Automatic	データバーの軸位置が自動的に計算されることを示します。
Middle	データバーの軸位置がセルの中心点になることを示します。
None	データバーの軸がないことを示します。

例

次のサンプルコードは、DataBarAxisPosition列挙体を使用します。

C#
Visual Basic

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

継承階層

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.DataBarAxisPosition

参照

FarPoint.Web.Spread 名前空間