GrapeCity.Windows.SpreadSheet.Data Namespace > TableStyle Class : FirstColumnStripSize Property |
'Declaration Public Property FirstColumnStripSize As System.Integer
'Usage Dim instance As TableStyle Dim value As System.Integer instance.FirstColumnStripSize = value value = instance.FirstColumnStripSize
public System.int FirstColumnStripSize {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.Windows.SpreadSheet.Data.TableStyleInfo tablestyle = new GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo(); tablestyle.Background = new SolidColorBrush(Colors.Red); tablestyle.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Purple); tablestyle.BorderTop = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkGray); tablestyle.BorderLeft = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); tablestyle.BorderRight = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo tablestylerow = new GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo(); tablestylerow.BorderBottom = new GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick); tablestylerow.Background = new SolidColorBrush(Colors.Green); GrapeCity.Windows.SpreadSheet.Data.TableStyle testtable = new GrapeCity.Windows.SpreadSheet.Data.TableStyle(); testtable.WholeTableStyle = tablestyle; testtable.FirstColumnStripStyle = tablestylerow; testtable.FirstColumnStripSize = 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.Windows.SpreadSheet.Data.TableStyleInfo() tablestyle.Background = New SolidColorBrush(Colors.Red) tablestyle.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Purple) tablestyle.BorderTop = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.DarkGray) tablestyle.BorderLeft = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) tablestyle.BorderRight = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) Dim tablestylerow As New GrapeCity.Windows.SpreadSheet.Data.TableStyleInfo() tablestylerow.BorderBottom = New GrapeCity.Windows.SpreadSheet.Data.BorderLine(System.Windows.Media.Colors.Red, GrapeCity.Windows.SpreadSheet.Data.BorderLineStyle.Thick) tablestylerow.Background = New SolidColorBrush(Colors.Green) Dim testtable As New GrapeCity.Windows.SpreadSheet.Data.TableStyle() testtable.WholeTableStyle = tablestyle testtable.FirstColumnStripStyle = tablestylerow testtable.FirstColumnStripSize = 2 Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, testtable) sTable.BandedColumns = True
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