Spread Silverlight Documentation
SetBorderOptions Enumeration
Example Example 


Specifies the options for the border setting.
Syntax
'Declaration
 
<System.FlagsAttribute()>
Public Enum SetBorderOptions 
   Inherits System.Enum
'Usage
 
Dim instance As SetBorderOptions
[System.Flags()]
public enum SetBorderOptions : System.Enum 
Members
MemberDescription
AllSpecifies all directions for the border.
BottomSpecifies the bottom border.
InnerHorizontalSpecifies the horizontal border.
InnerVerticalSpecifies the vertical border.
InsideSpecifies the inner horizontal and vertical borders.
LeftSpecifies the right left border.
OutLineSpecifies the left, top, right, and bottom borders.
RightSpecifies the right border.
TopSpecifies the top border.
Example
This example uses the SetBorderOptions enumeration.
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
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.