PowerTools SPREAD for ASP.NET 8.0J
AutoCalculation プロパティ (ICalculationSupport)

依存セルの内容が変更されたとき、シート内の各数式が自動的に再計算されるかどうかを取得または設定します。
構文
'Declaration
 
Property AutoCalculation As Boolean
bool AutoCalculation {get; set;}

プロパティ値

数式を自動的に再計算する場合はtrue、それ以外の場合はfalse
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 メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.