Spread Windows Forms 11.0 Product Documentation
Formula Property (Column)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Column Class : Formula Property
Gets or sets the formula for cells in this column.
Syntax
'Declaration
 
Public Property Formula As String
'Usage
 
Dim instance As Column
Dim value As String
 
instance.Formula = value
 
value = instance.Formula
public string Formula {get; set;}

Property Value

String containing the formula
Remarks

Columns objects returned by Columns.Default, ColumnHeader.Columns, and RowHeader.Columns do not have formulas.

Example
This example specifies the formula for the column.
FarPoint.Win.Spread.Column col;
col = fpSpread1.ActiveSheet.Columns[0];
fpSpread1.ActiveSheet.Cells[2, 3].Value = 10;
fpSpread1.ActiveSheet.Cells[2, 2].Value = 10;
col.Formula = "SUM(C2, D2)";
Dim col As FarPoint.Win.Spread.Column
col = fpSpread1.ActiveSheet.Columns(0)
fpSpread1.ActiveSheet.Cells(2, 3).Value = 10
fpSpread1.ActiveSheet.Cells(2, 2).Value = 10
col.Formula = "SUM(C2, D2)"
See Also

Reference

Column Class
Column Members