FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread 名前空間 > FpSpread クラス : GoalSeek メソッド |
'宣言
Public Function GoalSeek( _ ByVal variableSheet As Integer, _ ByVal variableRow As Integer, _ ByVal variableColumn As Integer, _ ByVal formulaSheet As Integer, _ ByVal formulaRow As Integer, _ ByVal formulaColumn As Integer, _ ByVal desiredResult As Double _ ) As Boolean
public bool GoalSeek( int variableSheet, int variableRow, int variableColumn, int formulaSheet, int formulaRow, int formulaColumn, double desiredResult )
fpSpread1.Sheets[0].Cells[1, 1].Formula = "C1+D1";
fpSpread1.Sheets[0].Cells[0, 3].Value = 2;
fpSpread1.GoalSeek(0, 0, 2, 0, 1, 1, 32);
FpSpread1.Sheets(0).Cells(1, 1).Formula = "C1+D1"
FpSpread1.Sheets(0).Cells(0, 3).Value = 2
FpSpread1.GoalSeek(0, 0, 2, 0, 1, 1, 32)