Spread Windows Forms 10.0 Product Documentation
GoalSeek Method (SpreadView)
Example 


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
Attempts to find a value 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 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)
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

Boolean: true if successful; false otherwise
Example
This example uses the GoalSeek method.
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);
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 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

See Also

Reference

SpreadView Class
SpreadView Members

 

 


Copyright © GrapeCity, inc. All rights reserved.