PowerTools SPREAD for Windows Forms 10.0J
Recalculate メソッド (DefaultSheetDataModel)


シートで最後の計算サイクル以降に変更された数式を評価します。
構文
'Declaration
 
Public Sub Recalculate() 
'使用法
 
Dim instance As DefaultSheetDataModel
 
instance.Recalculate()
public void Recalculate()
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 recalculate?", "Recalculate", MessageBoxButtons.YesNo)
If dlg = DialogResult.Yes Then
dataModel.SetValue(0, 0, 50)
dataModel.Recalculate()
End If
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
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 recalculate?", "Recalculate", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
dataModel.SetValue(0, 0, 50);
dataModel.Recalculate();
}
参照

DefaultSheetDataModel クラス
DefaultSheetDataModel メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.