Gets or sets the formula for cells in this column.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property Formula As String |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Column
Dim value As String
instance.Formula = value
value = instance.Formula |
| C# | |
|---|
public string Formula {get; set;} |
Property Value
String containing the formula
Remarks
Example
This example specifies the formula for the column.
| C# | Copy Code |
|---|
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)"; |
| Visual Basic | Copy Code |
|---|
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)" |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
