Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property AutoCalculation As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As DefaultSheetDataModel
Dim value As Boolean
instance.AutoCalculation = value
value = instance.AutoCalculation |
| C# | |
|---|
public bool AutoCalculation {get; set;} |
Property Value
Boolean:
true, for automatic recalculation,
false otherwise
Example
This example sets the AutoCalculation property.
| C# | Copy Code |
|---|
FarPoint.Web.Spread.Model.DefaultSheetDataModel dm = new FarPoint.Web.Spread.Model.DefaultSheetDataModel();
dm.AutoCalculation = true;
dm.ColumnCount = 3;
dm.RowCount = 3;
FpSpread1.ActiveSheetView.DataModel=dm; |
| VB.NET | Copy Code |
|---|
Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel()
dm.AutoCalculation = true
dm.ColumnCount = 3
dm.RowCount = 3
FpSpread1.ActiveSheetView.DataModel=dm |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also
