Items.ComputeValue Property (ExG2antt)

The ComputeValue property gets the result of a a computed or total field. The Item and ColIndex property refers the cells used as the source for the formula. Use the ComputeValue property to get the result of a total field. For instance, for a total field, the CellValue property indicates the formula, while the ComputeValue can be used to get the result of the formula at runtime.

The ComputeValue method returns the:

value of the computed field, where the ValueFormatType is exComputedField, and the Expression indicates the formula for the computed field.
value of the total field, where the ValueFormatType is exTotalField, and the Expression indicates a string as: aggregate(list,direction,formula)
text with no HTML formatting, where the ValueFormatType is exHTML, and the Expression indicates the string including the HTML format.

For instance, based on the ValueFormatType and Expression parameters the result could be:

exComputedField, dbl(%0) + dbl(%1), the sum between first two cells in the item referred by Item.
exTotalField, sum(current,dir,dbl(%0) + dbl(%1)), the total of first two columns, for all direct child items of the item being referred by Item.
exHTML, <b>bold</b>, returns bold ( returns the result with no HTML formatting ). In this case, the Item and ColIndex have no effect.

		Type	Description
		Expression as Variant	A string expression that specifies the formula to compute
		Item as Variant	A long expression that specifies the handle of the item.
		ColIndex as Variant	A long expression that indicates the column's index, a string expression that indicates the column's key or the column's caption.
		ValueFormatType as Variant	A ValueFormatType expression that indicates the type of the formula being interpreted by the Expression parameter. For instance, if the ValueFormatType parameter is exTotalField, the Expression parameter should inidcate a total formula of type aggregate(list,direction,formula)
		Variant	A string expression that indicates the result.