AutoCalculation Property (DefaultSheetDataModel)

Gets or sets whether the control automatically recalculates each formula in the sheet when the contents of dependent cells change.

Syntax

Visual Basic
C#

'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, for automatic recalculation, false otherwise

Example

This example sets the AutoCalculation property.

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

Dim dm As New FarPoint.Web.Spread.Model.DefaultSheetDataModel()
dm.AutoCalculation = true
dm.ColumnCount = 3
dm.RowCount = 3
FpSpread1.ActiveSheetView.DataModel=dm

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members