GoalSeek Method (FpSpread)

Attempts to find values for one cell that will produce the desired formula result in another cell.

Syntax

Visual Basic
C#

'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);

Visual Basic

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)

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members