- 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.ClearFormulas
ClearFormulas Method
ClearFormulas(int, int, int, int)
Removes all of the formulas from the specified range of cells.
Declaration
public virtual void ClearFormulas(int row, int column, int rowCount, int columnCount)Public Overridable Sub ClearFormulas(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of start of range to clear |
| int | column | Column index of start of range to clear |
| int | rowCount | Number of rows to clear |
| int | columnCount | Number of columns to clear |