Spread WinRT Documentation
GrapeCity.Xaml.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.
    private void Button_Click_1(object sender, RoutedEventArgs e)
            {
                gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Aquamarine);
                gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine();
                gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.BlueViolet, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot);
                gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Chartreuse);
                GrapeCity.Xaml.SpreadSheet.Data.CellRange r;
                r = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(2, 2, 2, 2);
                //gcSpreadSheet1.Sheets[0].SetBorder(r, new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green, GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All);
                gcSpreadSheet1.Sheets[0].SetBorder(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Cornsilk), GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All);
                gcSpreadSheet1.Sheets[0].Columns[5].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Crimson);
                gcSpreadSheet1.Sheets[0].Columns[5].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkBlue);
                gcSpreadSheet1.Sheets[0].Columns[5].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot);
                gcSpreadSheet1.Sheets[0].Columns[5].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkOliveGreen);
                gcSpreadSheet1.Sheets[0].SetBorder(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkOrchid), GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All);
                gcSpreadSheet1.Sheets[0].Rows[5].BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkSlateBlue);
                gcSpreadSheet1.Sheets[0].Rows[5].BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Firebrick);
                gcSpreadSheet1.Sheets[0].Rows[5].BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.ForestGreen, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot);
                gcSpreadSheet1.Sheets[0].Rows[5].BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Gold);                      
            }
    
            private void Button_Click_2(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();     
            }
    Private Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
            gcSpreadSheet1.Sheets(0).Cells(1, 1).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Aquamarine)
            gcSpreadSheet1.Sheets(0).Cells(1, 1).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine()
            gcSpreadSheet1.Sheets(0).Cells(1, 1).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.BlueViolet, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot)
            gcSpreadSheet1.Sheets(0).Cells(1, 1).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Chartreuse)
            Dim r As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(2, 2, 2, 2)
            'gcSpreadSheet1.Sheets(0).SetBorder(r, New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Green), GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All)
            gcSpreadSheet1.Sheets(0).SetBorder(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Cornsilk), GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All)
            gcSpreadSheet1.Sheets(0).Columns(5).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Crimson)
            gcSpreadSheet1.Sheets(0).Columns(5).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkBlue)
            gcSpreadSheet1.Sheets(0).Columns(5).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot)
            gcSpreadSheet1.Sheets(0).Columns(5).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkOliveGreen)
            gcSpreadSheet1.Sheets(0).SetBorder(r, GrapeCity.Xaml.SpreadSheet.Data.SheetArea.Cells, New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkOrchid), GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions.All)
            gcSpreadSheet1.Sheets(0).Rows(5).BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkSlateBlue)
            gcSpreadSheet1.Sheets(0).Rows(5).BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Firebrick)
            gcSpreadSheet1.Sheets(0).Rows(5).BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.ForestGreen, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.DashDot)
            gcSpreadSheet1.Sheets(0).Rows(5).BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Gold)
        End Sub
        
        Private Sub Button_Click_2(sender As Object, e As RoutedEventArgs)
            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()
        End Sub
    See Also