GrapeCity.Xaml.SpreadSheet.Data Namespace : SetBorderOptions Enumeration |
'Declaration <FlagsAttribute()> Public Enum SetBorderOptions Inherits System.Enum
'Usage Dim instance As SetBorderOptions
[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. |
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
System.Object
System.ValueType
System.Enum
GrapeCity.Xaml.SpreadSheet.Data.SetBorderOptions
Target Platforms: Windows Server 2012, Windows RT