Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Cell Class / BorderTop Property
Example


In This Topic
    BorderTop Property (Cell)
    In This Topic
    Gets or sets the top cell border.
    Syntax
    'Declaration
     
    <DefaultValueAttribute("")>
    Public Property BorderTop As BorderLine
    'Usage
     
    Dim instance As Cell
    Dim value As BorderLine
     
    instance.BorderTop = value
     
    value = instance.BorderTop
    [DefaultValue("")]
    public BorderLine BorderTop {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 BorderTop property.
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(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.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Cells[1, 1].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(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.FromRgb(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.FromRgb(25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All);
    gcSpreadSheet1.Sheets[0].Columns[5].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(100, 50, 100));
    gcSpreadSheet1.Sheets[0].Columns[5].BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5));
    gcSpreadSheet1.Sheets[0].Columns[5].BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Columns[5].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 50, 200));
    gcSpreadSheet1.Sheets[0].SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All);
    gcSpreadSheet1.Sheets[0].Rows[5].BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(100, 50, 100));
    gcSpreadSheet1.Sheets[0].Rows[5].BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5));
    gcSpreadSheet1.Sheets[0].Rows[5].BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot);
    gcSpreadSheet1.Sheets[0].Rows[5].BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(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.FromRgb(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.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Cells(1, 1).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(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.FromRgb(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.FromRgb(25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All)
    GcSpreadSheet1.Sheets(0).Columns(5).BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(100, 50, 100))
    GcSpreadSheet1.Sheets(0).Columns(5).BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5))
    GcSpreadSheet1.Sheets(0).Columns(5).BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Columns(5).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 50, 200))
    GcSpreadSheet1.Sheets(0).SetBorder(r, GrapeCity.Windows.SpreadSheet.Data.SheetArea.Cells, New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(25, 25, 200)), GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions.All)
    GcSpreadSheet1.Sheets(0).Rows(5).BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(100, 50, 100))
    GcSpreadSheet1.Sheets(0).Rows(5).BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5))
    GcSpreadSheet1.Sheets(0).Rows(5).BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(255, 122, 5), GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.DashDot)
    GcSpreadSheet1.Sheets(0).Rows(5).BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(Color.FromRgb(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