GoalSeek Method (DefaultSheetDataModel)

Attempts to find a value for one cell that produces the desired formula result in another cell.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GoalSeek( _
   ByVal variableRow As Integer, _
   ByVal variableColumn As Integer, _
   ByVal formulaDataModel As DefaultSheetDataModel, _
   ByVal formulaRow As Integer, _
   ByVal formulaColumn As Integer, _
   ByVal desiredResult As Double _
) As Boolean

'Usage
 
Dim instance As DefaultSheetDataModel
Dim variableRow As Integer
Dim variableColumn As Integer
Dim formulaDataModel As DefaultSheetDataModel
Dim formulaRow As Integer
Dim formulaColumn As Integer
Dim desiredResult As Double
Dim value As Boolean
 
value = instance.GoalSeek(variableRow, variableColumn, formulaDataModel, formulaRow, formulaColumn, desiredResult)

public bool GoalSeek( 
   int variableRow,
   int variableColumn,
   DefaultSheetDataModel formulaDataModel,
   int formulaRow,
   int formulaColumn,
   double desiredResult
)

Parameters

variableRow: Row index of cell that contains value to adjust
variableColumn: Column index of cell that contains value to adjust
formulaDataModel: Data model 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

Boolean: true if successful; false otherwise

Example

This example uses the GoalSeek method.

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = (FarPoint.Win.Spread.Model.DefaultSheetDataModel)fpSpread1.Sheets[0].Models.Data;
fpSpread1.Sheets[0].Cells[1, 1].Formula = "C1+D1";
fpSpread1.Sheets[0].Cells[0, 3].Value = 2;
dataModel.GoalSeek(0, 2, dataModel, 1, 1, 32);

Visual Basic

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5)
FpSpread1.ActiveSheet.Models.Data = dataModel
FpSpread1.Sheets(0).Cells(1, 1).Formula = "C1+D1"
FpSpread1.Sheets(0).Cells(0, 3).Value = 2
dataModel.GoalSeek(0, 2, dataModel, 1, 1, 32)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members