- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
- FarPoint.Win.Spread
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
-
FarPoint.Win.Spread.Model
-
Classes
- AggregateArgs
-
AggregationDataModel
- Constructors
- Properties
-
Methods
- AddColumns
- AddRows
- Clear
- Copy
- Deserialize
- Dispose
- GetCelAggregationType
- GetCellAggregationFormat
- GetFormula
- GetNote
- GetObjectData
- GetTag
- GetValue
- IsEditable
- IsEmpty
- IsRowUsed
- LoadFormulas
- Move
- NextNonEmptyColumnInRow
- NextNonEmptyRow
- RemoveColumns
- RemoveRows
- ResumeFormulaParsing
- Serialize
- SetCellAggregationFormat
- SetCellAggregationType
- SetFormula
- SetNote
- SetTag
- SetValue
- SuspendFormulaParsing
- Swap
- Events
- BaseSheetAxisModel
- BaseSheetDataModel
- BaseSheetSelectionModel
- BaseSheetSpanModel
- BaseSheetStyleModel
- CellRange
- CellRangeConverter
- ConvertTableToRangeEventArgs
- DefaultSheetAxisModel
- DefaultSheetDataModel
- DefaultSheetDataModel.CellEventArgs
- DefaultSheetDataModel.DefaultSheetDataModelEnumerator
- DefaultSheetDataModel.RowEventArgs
- DefaultSheetSelectionModel
- DefaultSheetSpanModel
- DefaultSheetStyleModel
- FormulaDependentInfos
- GeneralFormatter
- Group
- GroupDataModel
- GroupFooter
- InvalidExternalReferenceParseException
- InvalidNameException
- MapperUpdatingEventArgs
- ParseException
- PropertyChangingEventArgs
- SheetAxisModelChangingEventArgs
- SheetAxisModelEventArgs
- SheetAxisProperty
- SheetDataModelEventArgs
- SheetGroupDataModelEventArgs
- SheetSelectionModelEventArgs
- SheetSpanModelChangingEventArgs
- SheetSpanModelEventArgs
- SheetStyleModelEventArgs
- SpreadSerializer
- TableChangedEventArgs
- TableItemChangedEventArgs
- TableItemChangingEventArgs
- TableItemNameChangedEventArgs
- TableItemNameChangingEventArgs
- TableNameChangedEventArgs
- TableNameChangingEventArgs
- TableRangeChangedEventArgs
- TableRangeChangingEventArgs
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.Model.AggregationDataModel.Clear
Clear Method
Clear(int, int, int, int)
Removes all the data and formulas from the specified range of cells.
Declaration
public void Clear(int row, int column, int rowCount, int columnCount)Public Sub Clear(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 |