- 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
- Structs
- Enums
-
Interfaces
- IAboveAverage
- IAlternatingStyles
- IAreas
- IArray<T>
- IAuthor
- IAutoFilter
- IAutoFilterOwner
- IBorder
- IBorders
- ICellEditor
- ICellRenderer
- ICellType
- ICharacters
- IColorPalette
- IColorScale
- IColorScaleCriteria
- IColorScaleCriterion
- IColorStops
- IColumnFooter
- IColumnHeader
- IComment
- ICommentThreaded
- IComments
- ICommentsThreaded
- IConditionValue
- IDataManager
- IDatabar
- IDatabarBorder
- IFilter
- IFilters
- IFont
- IFormatCondition
- IFormatConditions
- IFormatter
- IGradient
- IGraphic
- IHyperlink
- IHyperlinks
- IIconCriteria
- IIconCriterion
- IIconSetCondition
- IInterior
- IMedia
- IName
- INames
- INegativeBarFormat
- INumFmtSupportCellType
- IOutline
- IProtection
-
IRange
- Properties
-
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
- UnMerge
- Ungroup
- IReadonlyArray<T>
- IRowHeader
- ISheet
- ISheetView
- ISheets
- ISort
- ISortComparer
- ISortField
- ISortFields
- ISparkAxes
- ISparkColor
- ISparkHorizontalAxis
- ISparkPoints
- ISparkVerticalAxis
- ISparkline
- ISparklineGroup
- ISparklineGroups
- IStyle
- IStyles
- ITable
- ITableColumn
- ITableColumns
- ITableRow
- ITableRows
- ITableStyle
- ITableStyleElement
- ITableStyleElements
- ITableStyles
- ITables
- ITop10
- IUniqueValues
- IValidation
- IWorkbook
- IWorkbookSet
- IWorkbooks
- IWorksheet
- IWorksheetStyles
- IWorksheetView
- IWorksheets
- 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.Delete
Delete Method
Delete(DeleteShiftDirection)
Delete a cell or a range of cells into the worksheet and shifts other cells.
Declaration
void Delete(DeleteShiftDirection shift = (DeleteShiftDirection)-1)Sub Delete(Optional shift As DeleteShiftDirection = -1)Parameters
| Type | Name | Description |
|---|---|---|
| DeleteShiftDirection | shift | A DeleteShiftDirection value indicates which way to shift the cells. If this argument is omitted, Spread decides based on the shape of the range. |