Syntax
| Visual Basic (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 | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
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) | |
| C# | |
|---|---|
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 otherwiseExample
This example uses the GoalSeek method.
| C# | Copy Code |
|---|---|
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 | Copy Code |
|---|---|
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2