dxSpreadSheetCalculateExpression(TdxSpreadSheetFormulaToken,TdxSpreadSheetFormulaResult,Boolean) Method

Evaluates the specified parsed formula expression token.

Declaration

procedure dxSpreadSheetCalculateExpression(AExpression: TdxSpreadSheetFormulaToken; var AResult: TdxSpreadSheetFormulaResult; const AForceConvertNullValueToZero: Boolean = False);

Parameters

Name	Type
AExpression	TdxSpreadSheetFormulaToken
AResult	TdxSpreadSheetFormulaResult
AForceConvertNullValueToZero	Boolean

Remarks

Call this procedure and pass a parsed formula expression token as the AExpression parameter to attempt to calculate its result. The procedure returns the result as the AResult var parameter.

Additionally, you can pass True as the optional AForceConvertNullValueToZero parameter value to convert a single Empty or Null Variant result value to 0. This parameter does not affect any Empty or Null Variant values in array results.