Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / TableStyle Class / FirstRowStripSize Property
Example


In This Topic
    FirstRowStripSize Property
    In This Topic
    The size of the first alternating row.
    Syntax
    'Declaration
     
    Public Property FirstRowStripSize As Integer
    'Usage
     
    Dim instance As TableStyle
    Dim value As Integer
     
    instance.FirstRowStripSize = value
     
    value = instance.FirstRowStripSize
    public int FirstRowStripSize {get; set;}
    Example
    This example creates a table.
    //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.FirstRowStripStyle = tablestylerow;
    testtable.FirstRowStripSize = 2;
    
    var sTable = GcSpreadSheet1.Sheets[0].AddTable("table1", 1, 1, 10, 5, testtable);
    '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.FirstRowStripStyle = tablestylerow
    testtable.FirstRowStripSize = 2
    Dim sTable = GcSpreadSheet1.Sheets(0).AddTable("table1", 1, 1, 10, 5, testtable)
    See Also