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

In This Topic
    BorderColor Property (DatabarConditionalFormattingRule)
    In This Topic
    Gets or sets the color of the border.
    Public Property BorderColor As Color
    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.
    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