Spread for ASP.NET 9.0 Product Documentation
AxisColor Property (DatabarConditionalFormattingRule)
Example 


Gets or sets the color of the axis.
Syntax
'Declaration
 
Public Property AxisColor As Color
'Usage
 
Dim instance As DatabarConditionalFormattingRule
Dim value As Color
 
instance.AxisColor = value
 
value = instance.AxisColor
public Color AxisColor {get; set;}

Property Value

The color of the axis.
Example
This example uses the AxisColor property.
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.DatabarConditionalFormattingRule d = new FarPoint.Web.Spread.DatabarConditionalFormattingRule();
            d.ShowBorder = true;
            d.AxisColor = System.Drawing.Color.DarkOrange;
            d.UseNegativeBorderColor = true;
            d.NegativeBorderColor = System.Drawing.Color.Green;
            d.FillColor = System.Drawing.Color.Bisque;
            d.NegativeFillColor = System.Drawing.Color.Aqua;
            d.Maximum = new FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number);
            FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d); 
        }
Protected Sub Page_Load(sender As Object, e As 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 d As New FarPoint.Web.Spread.DatabarConditionalFormattingRule()
        d.ShowBorder = True
        d.AxisColor = System.Drawing.Color.DarkOrange
        d.UseNegativeBorderColor = True
        d.NegativeBorderColor = System.Drawing.Color.Green
        d.FillColor = System.Drawing.Color.Bisque
        d.NegativeFillColor = System.Drawing.Color.Aqua
        d.Maximum = New FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number)
        FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d)
    End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

DatabarConditionalFormattingRule Class
DatabarConditionalFormattingRule Members

 

 


Copyright © GrapeCity, inc. All rights reserved.