Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / GoalSeek Method
Sheet index of cell that contains value to adjust
Row index of cell that contains value to adjust
Column index of cell that contains value to adjust
Sheet index of cell that contains formula
Row index of cell that contains formula
Column index of cell that contains formula
Formula result you wish to achieve
Example


In This Topic
    GoalSeek Method (FpSpread)
    In This Topic
    Attempts to find values for one cell that will produce the desired formula result in another cell.
    Syntax
    '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
    'Usage
     
    Dim instance As FpSpread
    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
    )

    Parameters

    variableSheet
    Sheet index of cell that contains value to adjust
    variableRow
    Row index of cell that contains value to adjust
    variableColumn
    Column index of cell that contains value to adjust
    formulaSheet
    Sheet index of cell that contains formula
    formulaRow
    Row index of cell that contains formula
    formulaColumn
    Column index of cell that contains formula
    desiredResult
    Formula result you wish to achieve

    Return Value

    true if value is found, false otherwise
    Example
    This example uses the GoalSeek method.
    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)
    
    
    See Also