GrapeCity.Xaml.SpreadSheet.Data Namespace > TableStyle Class : SecondColumnStripStyle Property |
'Declaration Public Property SecondColumnStripStyle As TableStyleInfo
'Usage Dim instance As TableStyle Dim value As TableStyleInfo instance.SecondColumnStripStyle = value value = instance.SecondColumnStripStyle
public TableStyleInfo SecondColumnStripStyle {get; set;}
//Add data for (var col = 1; col < 6; col++) { for (var row = 2; row < 11; row++) { GcSpreadSheet1.Sheets[0].SetValue(row, col, row + col); } } GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo tablestyle = new GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo(); tablestyle.Background = new SolidColorBrush(Windows.UI.Colors.Azure); tablestyle.BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Purple); tablestyle.BorderTop = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray); tablestyle.BorderLeft = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick); tablestyle.BorderRight = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick); GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo tablestylerow = new GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo(); tablestylerow.BorderBottom = new GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick); tablestylerow.Background = new SolidColorBrush(Windows.UI.Colors.Green); GrapeCity.Xaml.SpreadSheet.Data.TableStyle testtable = new GrapeCity.Xaml.SpreadSheet.Data.TableStyle(); testtable.WholeTableStyle = tablestyle; testtable.SecondColumnStripStyle = tablestylerow; testtable.SecondColumnStripSize = 2; var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, testtable); sTable.BandedColumns = true;
'Add data For col As Integer = 1 To 5 For row As Integer = 2 To 10 GcSpreadSheet1.Sheets(0).SetValue(row, col, row + col) Next Next Dim tablestyle As New GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo() tablestyle.Background = New SolidColorBrush(Windows.UI.Colors.Azure) tablestyle.BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Purple) tablestyle.BorderTop = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.DarkGray) tablestyle.BorderLeft = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick) tablestyle.BorderRight = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick) Dim tablestylerow As New GrapeCity.Xaml.SpreadSheet.Data.TableStyleInfo() tablestylerow.BorderBottom = New GrapeCity.Xaml.SpreadSheet.Data.BorderLine(Windows.UI.Colors.Red, GrapeCity.Xaml.SpreadSheet.Data.BorderLineStyle.Thick) tablestylerow.Background = New SolidColorBrush(Windows.UI.Colors.Green) Dim testtable As New GrapeCity.Xaml.SpreadSheet.Data.TableStyle() testtable.WholeTableStyle = tablestyle testtable.SecondColumnStripStyle = tablestylerow testtable.SecondColumnStripSize = 2 Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, testtable) sTable.BandedColumns = True
Target Platforms: Windows Server 2012, Windows RT