AutoCalculation プロパティ (ICalculationSupport)

依存セルの内容が変更されたとき、シート内の各数式が自動的に再計算されるかどうかを取得または設定します。

構文

Visual Basic
C#

'Declaration
 
Property AutoCalculation As Boolean

bool AutoCalculation {get; set;}

プロパティ値

数式を自動的に再計算する場合はtrue、それ以外の場合はfalse

例

C#
Visual Basic

FarPoint.Web.Spread.Model.ICalculationSupport cs; 
FpSpread1.ActiveSheetView.SetValue(0, 0, 20); 
FpSpread1.ActiveSheetView.SetValue(0, 1, 10); 
FpSpread1.ActiveSheetView.SetFormula(3, 0, "SUM(A1,B1)"); 

FpSpread1.ActiveSheetView.AutoCalculation = false; 
FpSpread1.ActiveSheetView.SetValue(0, 1, 100); 
cs = (FarPoint.Web.Spread.Model.ICalculationSupport)FpSpread1.ActiveSheetView.DataModel; 
cs.RecalculateAll();

Dim cs As FarPoint.Web.Spread.Model.ICalculationSupport
FpSpread1.ActiveSheetView.SetValue(0, 0, 20)
FpSpread1.ActiveSheetView.SetValue(0, 1, 10)
FpSpread1.ActiveSheetView.SetFormula(2, 0, "SUM(A1,B1)")

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim cs As FarPoint.Web.Spread.Model.ICalculationSupport
    FpSpread1.ActiveSheetView.AutoCalculation = False
    FpSpread1.ActiveSheetView.SetValue(0, 1, 100)
    cs = FpSpread1.ActiveSheetView.DataModel
    cs.RecalculateAll()
End Sub

参照

ICalculationSupport インタフェース
 ICalculationSupport メンバ