Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / TableStyle Class / FirstColumnStripe Property
Example


In This Topic
    FirstColumnStripe Property
    In This Topic
    Gets or sets the first column stripe of the table style.
    Syntax
    'Declaration
     
    Public Property FirstColumnStripe As TableElementStyle
    'Usage
     
    Dim instance As TableStyle
    Dim value As TableElementStyle
     
    instance.FirstColumnStripe = value
     
    value = instance.FirstColumnStripe
    public TableElementStyle FirstColumnStripe {get; set;}
    Example
    This example sets the banded column style.
    FarPoint.Win.ComplexBorderSide bside = new FarPoint.Win.ComplexBorderSide(Color.Yellow);
    FarPoint.Win.Spread.TableBorder tborder = new FarPoint.Win.Spread.TableBorder(bside);
    FarPoint.Win.Spread.TableElementStyle testyle = new FarPoint.Win.Spread.TableElementStyle(tborder, Color.Red, Color.Blue, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold);
    FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2);
    
    tstyle.FirstColumnStripe = testyle; //To set banded column
    
    fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
    fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
    fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
    fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
    fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
    fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
    fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
    fpSpread1.Sheets[0].Cells[4, 2].Value = 78;
    
    fpSpread1.TableStyleCollection.Add(tstyle);
    FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1"); 
    table.BandedColumns = true; //To show banded column
    Dim bside As New FarPoint.Win.ComplexBorderSide(Color.Yellow)
    Dim tborder As New FarPoint.Win.Spread.TableBorder(bside)
    Dim testyle As New FarPoint.Win.Spread.TableElementStyle(tborder, Color.Red, Color.Blue, FarPoint.Win.Spread.RegularBoldItalicFontStyle.Bold)
    Dim tstyle As FarPoint.Win.Spread.TableStyle
    tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2)
    
    tstyle.FirstColumnStripe = testyle 'To set banded column
    FpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
    FpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
    FpSpread1.Sheets(0).Cells(2, 1).Text = "Smith"
    FpSpread1.Sheets(0).Cells(2, 2).Value = 50
    FpSpread1.Sheets(0).Cells(3, 1).Text = "Vil"
    FpSpread1.Sheets(0).Cells(3, 2).Value = 10
    FpSpread1.Sheets(0).Cells(4, 1).Text = "Press"
    FpSpread1.Sheets(0).Cells(4, 2).Value = 78
    FpSpread1.TableStyleCollection.Add(tstyle)
    Dim table As FarPoint.Win.Spread.TableView =  FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1")
    table.BandedColumns = True 'To show banded column
    See Also