- 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.SetFormula
SetFormula Method
SetFormula(int, int, string)
Sets the formula, as a string value, for the cell of the specified row and column. If you pass null, it clears the expression from that cell.
Declaration
public void SetFormula(int row, int column, string value)Public Sub SetFormula(row As Integer, column As Integer, value As String)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of the cell |
| int | column | Column index of the cell |
| string | value | Formula to be set, as a string |
Implements
Exceptions
| Type | Condition |
|---|---|
| ParseException | Specified value is not a valid formula |