FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > ICalculationSupport Interface : Recalculate Method |
'Declaration Sub Recalculate()
'Usage Dim instance As ICalculationSupport instance.Recalculate()
void Recalculate()
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.Recalculate();
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.Recalculate() End Sub
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