Spread Windows Forms 11.0 Product Documentation
DataFormula Property (TableViewColumn)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > TableViewColumn Class : DataFormula Property
Gets or sets the formula in the data cells of the column.
Syntax
'Declaration
 
Public Property DataFormula As String
'Usage
 
Dim instance As TableViewColumn
Dim value As String
 
instance.DataFormula = value
 
value = instance.DataFormula
public string DataFormula {get; set;}
Example
This example sets the DataFormula 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, 3);
table.TableColumns[2].DataFormula = "$C$3+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
Dim table As FarPoint.Win.Spread.TableView = fpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 3)
table.TableColumns(2).DataFormula = "$C$3+2"
See Also

Reference

TableViewColumn Class
TableViewColumn Members