Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Tables / Adding a Table Formula
In This Topic
    Adding a Table Formula
    In This Topic

    You can add formulas to the table in a total row at run time with the Formula Editor or with code.

    Add a total row and then select the drop-down arrow at the bottom right corner of the table to display formulas.

    Table formula example

    You can select More Functions to display the Formula Editor as shown in the following figure.

    Formula Editor Dialog

    You can add formulas to the table with the Formula property. For more information about using structured references in table formulas, see Using Structured References.

    Setting Visibility of Total Row

    You can use the TotalRowVisible property to display the total row for the table. The following example adds a total row.

    C#
    Copy Code
    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;
    FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2);
    table.TotalRowVisible = true;
    
    VB
    Copy Code
    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
    Dim table As FarPoint.Win.Spread.TableView = fpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2)
    table.TotalRowVisible = True
    

    Automatically Create Calculated Columns

    You can automatically fill a column with the entered formula in the table by using the AutoCreateCalculatedColumns property. This property accepts a boolean value.

    C#
    Copy Code
    fpSpread1.Sheets[0].Cells[1, 3].Text = "Sum";
    
    fpSpread1.Features.AutoCreateCalculatedTableColumns = true;
    
    Visual Basic
    Copy Code
    FpSpread1.Sheets(0).Cells(1, 3).Text = "Sum"
    
    FpSpread1.Features.AutoCreateCalculatedTableColumns = True
    
    See Also