Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

dxSpreadSheetCalculateExpression(TdxSpreadSheetFormulaToken,TdxSpreadSheetFormulaResult,Boolean) Method

Evaluates the specified parsed formula expression token.

#Declaration

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

See Also