Spread Windows Forms 11.0 Product Documentation
AutoCalculation Property (DefaultSheetDataModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : AutoCalculation Property
Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.
Syntax
'Declaration
 
Public Property AutoCalculation As Boolean
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Boolean
 
instance.AutoCalculation = value
 
value = instance.AutoCalculation
public bool AutoCalculation {get; set;}

Property Value

Boolean: true to automatically recalculate formulas; false otherwise
Example
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
Dim dlg As DialogResult
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, 10)
dataModel.SetValue(1, 0, 20)
dataModel.SetFormula(1, 1, "3*SUM(A1, A2)")
dlg = MessageBox.Show("Do you want to AutoCalculate the formula??", "AutoCalculation", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
dataModel.SetValue(1, 0, 80)
dataModel.AutoCalculation = True
End If
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
DialogResult dlg;
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, 10);
dataModel.SetValue(1, 0, 20);
dataModel.SetFormula(1, 1, "3*SUM(A1, A2)");
dlg = MessageBox.Show("Do you want to AutoCalculate the formula??", "AutoCalculation", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
dataModel.SetValue(1, 0, 80);
dataModel.AutoCalculation = true;
}
See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members