FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > SpreadView クラス : GoalSeek メソッド |
'Declaration 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
'使用法 Dim instance As SpreadView Dim variableSheet As Integer Dim variableRow As Integer Dim variableColumn As Integer Dim formulaSheet As Integer Dim formulaRow As Integer Dim formulaColumn As Integer Dim desiredResult As Double Dim value As Boolean value = instance.GoalSeek(variableSheet, variableRow, variableColumn, formulaSheet, formulaRow, formulaColumn, desiredResult)
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)