[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.IRange.Insert

Insert Method

Insert(InsertShiftDirection, InsertFormatOrigin)

Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space.

Declaration
void Insert(InsertShiftDirection shift = (InsertShiftDirection)-1, InsertFormatOrigin origin = InsertFormatOrigin.LeftOrAbove)
Sub Insert(Optional shift As InsertShiftDirection = -1, Optional origin As InsertFormatOrigin = InsertFormatOrigin.LeftOrAbove)
Parameters
Type Name Description
InsertShiftDirection shift

A InsertShiftDirection value indicates which way to shift the cells. If this argument is omitted, Spread decides based on the shape of the range.

InsertFormatOrigin origin

A InsertFormatOrigin value indicates where to copy the format for inserted cells.