Attempt to find value for one cell that will produce desired formula result in another cell.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
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) |
Parameters
- variableSheet
- Sheet index of cell that contains value to adjust
- variableRow
- Row index of cell that contains 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
Boolean:
true if successful;
false otherwise
Example
This example uses the GoalSeek method.
| C# | Copy Code |
|---|
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); |
| Visual Basic | Copy Code |
|---|
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) |
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
See Also
