Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DatabarConditionalFormattingRule Class / BorderColor Property
Example


In This Topic
    BorderColor Property (DatabarConditionalFormattingRule)
    In This Topic
    Gets or sets the color of the border.
    Syntax
    'Declaration
     
    Public Property BorderColor As Color
    'Usage
     
    Dim instance As DatabarConditionalFormattingRule
    Dim value As Color
     
    instance.BorderColor = value
     
    value = instance.BorderColor
    public Color BorderColor {get; set;}

    Property Value

    The color of the border.
    Example
    This example sets the BorderColor property.
    protected void Page_Load(object sender, System.EventArgs e)
                           {
                               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;  
                           }
    
    protected void Button1_Click(object sender, EventArgs e)
            {
                //Date Occurs CF
                FarPoint.Web.Spread.DatabarConditionalFormattingRule d = new FarPoint.Web.Spread.DatabarConditionalFormattingRule();
                d.BorderColor = Color.Red;
                d.ShowBorder = true;
                d.Maximum = new FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number);
                FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d);
            }
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
                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
            End Sub
    
    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                Dim d As New FarPoint.Web.Spread.DatabarConditionalFormattingRule()
                d.BorderColor = Drawing.Color.Red
                d.ShowBorder = True
                d.Maximum = New FarPoint.Web.Spread.ConditionalFormattingValue(15, FarPoint.Web.Spread.ConditionalFormattingValueType.Number)
                FpSpread1.ActiveSheetView.SetConditionalFormatting(0, 0, 3, 3, d)
            End Sub
    See Also