GrapeCity.Windows.SpreadSheet.Data Namespace : BorderLineStyle Enumeration |
'Declaration Public Enum BorderLineStyle Inherits System.Enum
'Usage Dim instance As BorderLineStyle
public enum BorderLineStyle : System.Enum
Member | Description |
---|---|
DashDot | Indicates a border line with dash-dot. |
DashDotDot | Indicates a border line with dash-dot-dot. |
Dashed | Indicates a border line with dashes. |
Dotted | Indicates a border line with dots. |
Double | Indicates a double border line. |
Hair | Indicates a border line with all dots. |
Medium | Indicates a medium border line with a solid line. |
MediumDashDot | Indicates a medium border line with dash-dot-dot. |
MediumDashDotDot | Indicates a medium border line with dash-dot-dot. |
MediumDashed | Indicates a medium border line with dashes. |
None | Indicates a border line without a style. |
SlantedDashDot | Indicates a slanted border line with dash-dot. |
Thick | Indicates a thick border line with a solid line. |
Thin | Indicates a border line with a solid thin line. |
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.BorderLineStyle
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