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

In This Topic
    Formula Property (Column)
    In This Topic
    Gets or sets the formula for cells in this column.
    Public Property Formula As String
    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

    Columns objects returned by Columns.Default, ColumnHeader.Columns, and RowHeader.Columns do not have formulas.

    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