Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum DataBarAxisPosition Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As DataBarAxisPosition | |
| C# | |
|---|---|
public enum DataBarAxisPosition : System.Enum | |
Members
| Member | Description |
|---|---|
| Automatic | Indicates that the axis position for the data bar is calculated automatically. |
| Middle | Indicates that the axis position for the data bar is the midpoint of the cell. |
| None | Indicates that there is no axis for the data bar. |
Example
This example uses the DataBarAxisPosition enumeration.
| C# | Copy Code |
|---|---|
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); } | |
| VB.NET | Copy Code |
|---|---|
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 | |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.DataBarAxisPosition
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6