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.
<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.
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