FarPoint.Win.Spread アセンブリ > FarPoint.Win.Spread 名前空間 > SpreadView クラス : 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 )
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
fpSpread1.Sheets[0].Cells[1, 1].Formula = "C1+D1";
fpSpread1.Sheets[0].Cells[0, 3].Value = 2;
sv.GoalSeek(0, 0, 2, 0, 1, 1, 32);
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook FpSpread1.Sheets(0).Cells(1, 1).Formula = "C1+D1" FpSpread1.Sheets(0).Cells(0, 3).Value = 2 sv.GoalSeek(0, 0, 2, 0, 1, 1, 32)