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


In This Topic
    FirstTotalCell Property
    In This Topic
    Gets or sets the first total cell of the table style.
    Syntax
    'Declaration
     
    Public Property FirstTotalCell As TableElementStyle
    'Usage
     
    Dim instance As TableStyle
    Dim value As TableElementStyle
     
    instance.FirstTotalCell = value
     
    value = instance.FirstTotalCell
    public TableElementStyle FirstTotalCell {get; set;}
    Example
    This example creates a style for the first total cell.
    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.FirstTotalCell = testyle;
    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.TotalRowVisible = true;
    fpSpread1.Sheets[0].Cells[6, 1].Formula = "SUM(table[Value])";
    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.FirstTotalCell = testyle
    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.TotalRowVisible = True
    FpSpread1.Sheets(0).Cells(6, 1).Formula = "SUM(table[Value])"
    See Also