GrapeCity.Windows.SpreadSheet.Data Namespace : SetBorderOptions Enumeration |
'Declaration <System.FlagsAttribute()> Public Enum SetBorderOptions Inherits System.Enum
'Usage Dim instance As SetBorderOptions
[System.Flags()] public enum SetBorderOptions : System.Enum
Member | Description |
---|---|
All | Specifies all directions for the border. |
Bottom | Specifies the bottom border. |
InnerHorizontal | Specifies the horizontal border. |
InnerVertical | Specifies the vertical border. |
Inside | Specifies the inner horizontal and vertical borders. |
Left | Specifies the right left border. |
OutLine | Specifies the left, top, right, and bottom borders. |
Right | Specifies the right border. |
Top | Specifies the top border. |
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
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.SetBorderOptions
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