Spread Windows Forms 10.0 Product Documentation
SetDataColumnFormula Method (TableView)
Example 


Column index.
Formula string.
Sets data formula in a special column.
Syntax
'Declaration
 
Public Sub SetDataColumnFormula( _
   ByVal columnIndex As Integer, _
   ByVal formula As String _
) 
'Usage
 
Dim instance As TableView
Dim columnIndex As Integer
Dim formula As String
 
instance.SetDataColumnFormula(columnIndex, formula)
public void SetDataColumnFormula( 
   int columnIndex,
   string formula
)

Parameters

columnIndex
Column index.
formula
Formula string.
Example
Type numbers in column1 and column2 to see the formula result.
FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2);
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, 5, "Style1");
table.SetColumnNames(new string[] { "Column1", "Column2", "Column3" });
//Type numbers in Column1 and Column2 to see the formula result
table.SetDataColumnFormula(4, "[@Column1]*[@Column2]");
Dim tstyle As FarPoint.Win.Spread.TableStyle
tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2)
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, 5, "Style1")
table.SetColumnNames(New String() {"Column1", "Column2", "Column3"})
table.SetDataColumnFormula(4, "[@Column1]*[@Column2]")
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

TableView Class
TableView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.