IWbs.SetColumnFormula Method

NOTE: This member is now obsolete. Use Qdv.UserApi.Fields.IWbsField.Formula instead. This is a newer and more flexible API that was introduced in QDV 7.18.655. Access the WBS fields via Qdv.UserApi.IEstimate.WbsFieldsRepository property.

Sets the formula in a free column of the WBS.
<Obsolete("Use Qdv.UserApi.Fields.IWbsField.Formula instead.
This is a newer and more flexible API that was introduced in QDV 7.18.655. Access the WBS fields via Qdv.UserApi.IEstimate.WbsFieldsRepository property.")> _ 
Sub SetColumnFormula( _ 
ByVal columnNameOrUniqueIdentifier As String, _ 
ByVal formulaInEnglish As String, _ 
Optional ByVal useUniqueIdentifierInstead As Boolean = False _ 
)
This language is not supported or no code example is available.
[Obsolete("Use Qdv.UserApi.Fields.IWbsField.Formula instead.
This is a newer and more flexible API that was introduced in QDV 7.18.655. Access the WBS fields via Qdv.UserApi.IEstimate.WbsFieldsRepository property.")] 
void SetColumnFormula( 
string columnNameOrUniqueIdentifier
string formulaInEnglish
bool useUniqueIdentifierInstead = False 
)
This language is not supported or no code example is available.

Parameters

columnNameOrUniqueIdentifier
string

The name identifier to the column or the unique identifier to the column

formulaInEnglish
string

The formula in the neutral En-us language. It is in the Excel format, i.e. other columns are referenced with A1 notation (e.g. AA5*5) and not with newer field mnemonic notation (e.g. [WBS_Quantity]*5). The list separator must be "," and decimal separator must be "." regardless the locale of the system. The formula must refer to row 5

useUniqueIdentifierInstead
bool

Optional. The default value is False.If set to true, then the unique identifier to the column is taken; otherwise, the name identifier of the column is taken.

Remarks
 

When name identifier is used, there can be multiple columns, so the function assigns the formula to all columns. This can occurs when a column from the minutes is broken down.

The columns set to receive the formulas must be free columns with the 'Use formula' activated.

The formula must always refer to row 5 and only row 5. E.g: AA5+AC5/AE5

Version
 
Available since QDV 7.17.646.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition