Spread Windows Forms 12.0 Product Documentation
AutoCalculation Property (DefaultSheetDataModel)

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.
Public Property AutoCalculation As Boolean
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
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


DefaultSheetDataModel Class
DefaultSheetDataModel Members