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

TdxSpreadSheetCustomFormula.Value Property

Returns the formula expression’s calculation result.

#Declaration

Delphi
property Value: Variant read;

#Property Value

Type
Variant

#Remarks

The calculation result returned by this property is displayed in a cell instead of the formula expression by default:

The Spreadsheet or Report Designer control displays formula expressions as text instead of calculated values in the active worksheet if one of the following conditions is met:

The Value property returns 0 if the formula expression result is not yet calculated; otherwise – returns ResultValue.Value.

The Spreadsheet and Report Designer controls calculate their formulas automatically if the OptionsBehavior.AutomaticCalculation property is set to True. You can call the Controller.Calculate procedure to calculate or recalculate the formula expression result.

See Also