Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / Row Class / BorderLeft Property
Example


In This Topic
    BorderLeft Property (Row)
    In This Topic
    Gets or sets the left border for a row.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Property BorderLeft As BorderLine
    'Usage
     
    Dim instance As Row
    Dim value As BorderLine
     
    instance.BorderLeft = value
     
    value = instance.BorderLeft
    [DefaultValue("")]
    public BorderLine BorderLeft {get; set;}

    Property Value

    The border for cells in this row. The default value is null, which means that no border is set for this row.
    Example
    This example sets the BorderLeft 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