FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SheetView クラス : RecalculateAll メソッド |
'Declaration Public Sub RecalculateAll()
'使用法 Dim instance As SheetView instance.RecalculateAll()
public void RecalculateAll()
DialogResult dlg; fpSpread1.ActiveSheet.SetValue(0, 0, 20); fpSpread1.ActiveSheet.SetValue(0, 1, 10); fpSpread1.ActiveSheet.SetFormula(3, 0, "SUM(A1,B1)"); fpSpread1.ActiveSheet.SetFormula(4, 0, "A1*B1"); dlg = MessageBox.Show("Do you want to recalculate the formulas?", "RecalculateAll", MessageBoxButtons.YesNo); if (dlg == DialogResult.Yes) { fpSpread1.ActiveSheet.SetValue(0, 1, 100); fpSpread1.ActiveSheet.RecalculateAll(); }
Dim dlg As DialogResult FpSpread1.ActiveSheet.SetValue(0, 0, 20) FpSpread1.ActiveSheet.SetValue(0, 1, 10) FpSpread1.ActiveSheet.SetFormula(3, 0, "SUM(A1,B1)") FpSpread1.ActiveSheet.SetFormula(4, 0, "A1*B1") dlg = MessageBox.Show("Do you want to recalculate the formulas?", "RecalculateAll", MessageBoxButtons.YesNo) If dlg = DialogResult.Yes Then FpSpread1.ActiveSheet.SetValue(0, 1, 100) FpSpread1.ActiveSheet.RecalculateAll() End If