Spread Windows Forms 15.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Table Class / SetColumnFormula Method
An integer value indicates the calculated column index.
A string value indicates formula of the calculated column. The first cell of data area will be count as context cell.
if set to true, all cells of table column will be filled with the expression.
if set to true, all cells of table column will be filled with the expression if they're all empty.


In This Topic
    SetColumnFormula Method
    In This Topic
    Sets the calculated column's formula.
    Syntax
    'Declaration
     
    
    Public Function SetColumnFormula( _
       ByVal index As Integer, _
       ByVal formula As String, _
       Optional ByVal alwaysFill As Boolean, _
       Optional ByVal fillIfEmpty As Boolean _
    ) As Boolean
    'Usage
     
    
    Dim instance As Table
    Dim index As Integer
    Dim formula As String
    Dim alwaysFill As Boolean
    Dim fillIfEmpty As Boolean
    Dim value As Boolean
     
    value = instance.SetColumnFormula(index, formula, alwaysFill, fillIfEmpty)
    public bool SetColumnFormula( 
       int index,
       string formula,
       bool alwaysFill,
       bool fillIfEmpty
    )

    Parameters

    index
    An integer value indicates the calculated column index.
    formula
    A string value indicates formula of the calculated column. The first cell of data area will be count as context cell.
    alwaysFill
    if set to true, all cells of table column will be filled with the expression.
    fillIfEmpty
    if set to true, all cells of table column will be filled with the expression if they're all empty.

    Return Value

    true if the formula is set successful, false otherwise.
    See Also