TdxSpreadSheetCustomFormula.Value Property

Returns the formula expression’s calculation result.

Declaration

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 control’s OptionsView.ShowFormulas property is set to True and the worksheet’s Options.ShowFormuals property is set to bDefault;

• The worksheet’s Options.ShowFormulas property is set to bTrue.

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.