Spread Windows Forms 11.0 Product Documentation
TotalFormula Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > TableViewColumn Class : TotalFormula Property
Gets or sets the formula in the total cell of the column.
Syntax
'Declaration
 
Public Property TotalFormula As String
'Usage
 
Dim instance As TableViewColumn
Dim value As String
 
instance.TotalFormula = value
 
value = instance.TotalFormula
public string TotalFormula {get; set;}
Example
This example sets the TotalFormula property.
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;
table.TableColumns[1].TotalFormula = "C3+C4";
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
table.TableColumns(1).TotalFormula = "C3+C4"
See Also

Reference

TableViewColumn Class
TableViewColumn Members