Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / Formula Property
Example


In This Topic
    Formula Property (Column)
    In This Topic
    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