Spread WinForms 15
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)

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