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

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

Reference

Column Class
Column Members