Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Cell Class / BorderBottom Property
Example


In This Topic
    BorderBottom Property (Cell)
    In This Topic
    Gets or sets the right cell border.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Property BorderBottom As BorderLine
    'Usage
     
    Dim instance As Cell
    Dim value As BorderLine
     
    instance.BorderBottom = value
     
    value = instance.BorderBottom
    [DefaultValue("")]
    public BorderLine BorderBottom {get; set;}

    Property Value

    A BorderLine object that specifies the border for the cell. The default value is null, which means the cell inherits the border set for the column or row.
    Example
    This example sets the BorderBottom property.
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100));
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine();
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200));
    GrapeCity.Windows.SpreadSheet.Data.CellRange r;
    r = new GrapeCity.Windows.SpreadSheet.Data.CellRange(2, 2, 2, 2);            
    //gcSpreadSheet1.Sheets[0].SetBorder(r, new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 25,25,200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All);
    gcSpreadSheet1.Sheets[0].SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All);
    gcSpreadSheet1.Sheets[0].Columns[5].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100));
    gcSpreadSheet1.Sheets[0].Columns[5].BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5));
    gcSpreadSheet1.Sheets[0].Columns[5].BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Columns[5].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200));
    gcSpreadSheet1.Sheets[0].SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255,25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All);
    gcSpreadSheet1.Sheets[0].Rows[5].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100));
    gcSpreadSheet1.Sheets[0].Rows[5].BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5));
    gcSpreadSheet1.Sheets[0].Rows[5].BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Rows[5].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200));
    gcSpreadSheet1.Invalidate();
    
    private void button1_Click(object sender, RoutedEventArgs e)
            {
                listBox1.Items.Add(gcSpreadSheet1.Sheets[0].Cells[1, 1].ActualBorderBottom.ToString());
                gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetBorderBottom();
                gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetBorderLeft();
                gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetBorderRight();
                gcSpreadSheet1.Sheets[0].Cells[1, 1].ResetBorderTop();
                gcSpreadSheet1.Invalidate();
            }
    GcSpreadSheet1.Sheets(0).Cells(1, 1).BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100))
    GcSpreadSheet1.Sheets(0).Cells(1, 1).BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine()
    GcSpreadSheet1.Sheets(0).Cells(1, 1).BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Cells(1, 1).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200))
    Dim r As New GrapeCity.Windows.SpreadSheet.Data.CellRange(2, 2, 2, 2)
     'GcSpreadSheet1.Sheets(0).SetBorder(r, new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 25,25,200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All)
    GcSpreadSheet1.Sheets(0).SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255,25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All)
    GcSpreadSheet1.Sheets(0).Columns(5).BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100))
    GcSpreadSheet1.Sheets(0).Columns(5).BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5))
    GcSpreadSheet1.Sheets(0).Columns(5).BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Columns(5).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200))
    GcSpreadSheet1.Sheets(0).SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255,25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All)
    GcSpreadSheet1.Sheets(0).Rows(5).BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 100, 50, 100))
    GcSpreadSheet1.Sheets(0).Rows(5).BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5))
    GcSpreadSheet1.Sheets(0).Rows(5).BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Rows(5).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromArgb(255, 255, 50, 200))
    GcSpreadSheet1.Invalidate()
    
    Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
           ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).Cells(1, 1).ActualBorderBottom.ToString())
                GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetBorderBottom()
                GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetBorderLeft()
                GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetBorderRight()
                GcSpreadSheet1.Sheets(0).Cells(1, 1).ResetBorderTop()
                GcSpreadSheet1.Invalidate()
        End Sub
    See Also