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


In This Topic
    FirstColumnStripSize Property
    In This Topic
    Gets or sets the size for the first column strip.
    Syntax
    'Declaration
     
    Public Property FirstColumnStripSize As Integer
    'Usage
     
    Dim instance As TableStyle
    Dim value As Integer
     
    instance.FirstColumnStripSize = value
     
    value = instance.FirstColumnStripSize
    public int FirstColumnStripSize {get; set;}
    Example
    This example creates a 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
    tstyle.FirstColumnStripSize = 2;
    
    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
    tstyle.FirstColumnStripSize = 2
    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