- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
- FarPoint.Win.Spread Assembly
- GrapeCity.CalcEngine Assembly
-
GrapeCity.Spreadsheet Assembly
- GrapeCity.CalcEngine
- GrapeCity.Core
-
GrapeCity.Spreadsheet
- Classes
- Enums
-
Interfaces
- IAboveAverage
- IAlternatingStyles
- IAreas
- IArray<T>
- IAuthor
- IAutoFilter
- IAutoFilterOwner
- IBorder
- IBorders
- ICellEditor
- ICellRenderer
- ICellType
- ICharacters
- IColorPalette
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStops
- IColumnFooter
- IColumnHeader
- IComment
- IComments
- ICommentsThreaded
- ICommentThreaded
- IConditionValue
- IDatabar
- IDatabarBorder
- IDataManager
- IFilter
- IFilters
- IFont
- IFormatCondition
- IFormatConditions
- IFormatter
- IGradient
- IGraphic
- IHyperlink
- IHyperlinks
- IIconCriteria
- IIconCriterion
- IIconSetCondition
- IInterior
- IMedia
- IName
- INames
- INegativeBarFormat
- INumFmtSupportCellType
- IOutline
- IProtection
-
IRange
-
Methods
- Activate
- AddComment
- AddCommentThreaded
- Address
- ApplyNumberFormat
- ApplyStyle
- ApplyStyleFormat
- AutoFill
- AutoFilter
- AutoFit
- BorderAround
- Calculate
- Characters
- Clear
- ClearHyperlinks
- Copy
- CreateCamera
- CreateTable
- Cut
- DataTable
- Delete
- Dirty
- End
- FillDown
- FillLeft
- FillRight
- FillUp
- Find
- FindNext
- FindPrevious
- GetFullDependents
- GetFullPrecedents
- GoalSeek
- Group
- Insert
- InsertIndent
- InsertPictureInCell
- Merge
- Move
- Offset
- PastePictureInCell
- PasteSpecial
- Range
- RemoveDuplicates
- Resize
- Select
- Show
- ShowCard
- SpecialCells
- TextToColumns
- Ungroup
- UnMerge
- Properties
-
Methods
- IReadonlyArray<T>
- IRowHeader
- ISheet
- ISheets
- ISheetView
- ISort
- ISortComparer
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- ISparkPoints
- ISparkVerticalAxis
- IStyle
- IStyles
- ITable
- ITableColumn
- ITableColumns
- ITableRow
- ITableRows
- ITables
- ITableStyle
- ITableStyleElement
- ITableStyleElements
- ITableStyles
- ITop10
- IUniqueValues
- IValidation
- IWorkbook
- IWorkbooks
- IWorkbookSet
- IWorksheet
- IWorksheets
- IWorksheetStyles
- IWorksheetView
- Structs
- GrapeCity.Spreadsheet.Charts
- GrapeCity.Spreadsheet.Commands
- GrapeCity.Spreadsheet.Drawing
- GrapeCity.Spreadsheet.IO
- GrapeCity.Spreadsheet.IO.OpenXml
- GrapeCity.Spreadsheet.IO.Pdf
- GrapeCity.Spreadsheet.Localization
- GrapeCity.Spreadsheet.Printing
- GrapeCity.Spreadsheet.Slicers
- GrapeCity.Spreadsheet.UI
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
GrapeCity.Spreadsheet.IRange.Clear
Clear Method
Clear(ManipulationOptions)
Removes all the data and formulas from the specified range of cells.
Declaration
bool Clear(ManipulationOptions options = ManipulationOptions.All)Function Clear(Optional options As ManipulationOptions = ManipulationOptions.All) As BooleanParameters
| Type | Name | Description |
|---|---|---|
| ManipulationOptions | options | The options indicates which data type will be performed. If this argument is omitted, all data will be clear. |
Returns
| Type | Description |
|---|---|
| bool |
|