GrapeCity.Xaml.SpreadSheet.Data
BorderLeft Property (Cell)
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > Cell Class : BorderLeft Property
Gets or sets the left cell border.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property BorderLeft As BorderLine
'Usage
 
Dim instance As Cell
Dim value As BorderLine
 
instance.BorderLeft = value
 
value = instance.BorderLeft
[DefaultValue()]
public BorderLine BorderLeft {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 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

Reference

Cell Class
Cell Members