- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.Web.Chart Assembly
-
FarPoint.Web.Spread Assembly
- FarPoint.Web.Spread
- FarPoint.Web.Spread.Chart
- FarPoint.Web.Spread.Data
- FarPoint.Web.Spread.Editor
-
FarPoint.Web.Spread.Model
-
Classes
- AggregateArgs
- AutoFilterIndexChangedEventArgs
- BaseSheetAxisModel
- BaseSheetDataModel
- BaseSheetSelectionModel
- BaseSheetSpanModel
- BaseSheetStyleModel
- CellRange
- CellRangeConverter
- DefaultSheetAxisModel
-
DefaultSheetDataModel
- Constructors
- Properties
-
Methods
- AddColumn
- AddColumns
- AddCustomFunction
- AddCustomName
- AddRow
- AddRowToDataSource
- AddRows
- AddUnboundRows
- Clear
- ClearCustomFunctions
- ClearCustomNames
- ClearData
- ClearFormulas
- CompareExpression
- Copy
- CreateDataSourceSelectArguments
- Deserialize
- EvaluateExpression
- FireChanged
- GetAggregationResult
- GetAggregationType
- GetArray
- GetChildDataModel
- GetChildRelation
- GetColumnIndex
- GetCustomFunction
- GetCustomFunctionEnumerator
- GetCustomName
- GetCustomNameEnumerator
- GetDataColumnCaption
- GetDataColumnFromModelColumn
- GetDataColumnName
- GetDataColumnType
- GetDataRow
- GetDataRowFromModelRow
- GetDataTable
- GetDataView
- GetExpression
- GetFormula
- GetItem
- GetKey
- GetListSource
- GetModelColumnFromDataColumn
- GetModelRowFromDataRow
- GetNonEmptyNotesColumnCount
- GetNonEmptyNotesRowCount
- GetNote
- GetObjectData
- GetTag
- GetUnboundValue
- GetValue
- GoalSeek
- IsColumnBound
- IsEditable
- IsEmpty
- IsRowBound
- IsRowUsed
- LoadFormulas
- Move
- NextNonEmptyColumnInRow
- NextNonEmptyRow
- OnAggregate
- OnChanged
- OnDataSourceViewChanged
- ParseFormula
- Recalculate
- RecalculateAll
- RemoveColumn
- RemoveColumns
- RemoveCustomFunction
- RemoveCustomName
- RemoveRow
- RemoveRows
- Serialize
- Serialize2
- SetAggregationType
- SetArray
- SetExpression
- SetFormula
- SetModelDataColumn
- SetNote
- SetTag
- SetValue
- Swap
- UnparseFormula
- Events
- DefaultSheetDataModel.DefaultSheetDataModelEnumerator
- DefaultSheetSelectionModel
- DefaultSheetSpanModel
- DefaultSheetStyleModel
- GeneralFormatter
- Group
- GroupDataModel
- GroupFooter
- InvalidExternalReferenceParseException
- ParseException
- PropertyChangingEventArgs
- RequestRowVisibleStatesEventArgs
- Serializer
- SheetAxisModelChangingEventArgs
- SheetAxisModelEventArgs
- SheetAxisProperty
- SheetDataModelEventArgs
- SheetGroupDataModelEventArgs
- SheetSelectionModelEventArgs
- SheetStyleModelEventArgs
- SpreadSerializer
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Web.Spread.Renderer
- FarPoint.Web.Spread.Extender Assembly
FarPoint.Web.Spread.Model.DefaultSheetDataModel.GoalSeek
GoalSeek Method
GoalSeek(int, int, DefaultSheetDataModel, int, int, double)
Attempts to find a value for one cell that produces the desired formula result in another cell.
Declaration
public bool GoalSeek(int variableRow, int variableColumn, DefaultSheetDataModel formulaDataModel, int formulaRow, int formulaColumn, double desiredResult)Public Function GoalSeek(variableRow As Integer, variableColumn As Integer, formulaDataModel As DefaultSheetDataModel, formulaRow As Integer, formulaColumn As Integer, desiredResult As Double) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| int | variableRow | Row index of cell that contains value to adjust |
| int | variableColumn | Column index of cell that contains value to adjust |
| DefaultSheetDataModel | formulaDataModel | Data model of cell that contains formula |
| int | formulaRow | Row index of cell that contains formula |
| int | formulaColumn | Column index of cell that contains formula |
| double | desiredResult | Formula result you wish to achieve |
Returns
| Type | Description |
|---|---|
| bool |