Formula Property (Column)

Gets or sets the formula for cells in this column.

Syntax

Visual Basic
C#

'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)";

Visual Basic

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)"

Reference

Column Class
Column Members