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


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

Column Class
Column Members

 

 


Copyright © GrapeCity, inc. All rights reserved.