Sets the calculated column's formula.
'Declaration
Public Function SetColumnFormula( _
ByVal As Integer, _
ByVal As String, _
Optional ByVal As Boolean, _
Optional ByVal 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.