InsertCellsMode Enum

Specifies how to insert new cells into a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

public enum InsertCellsMode

VB.NET

Public Enum InsertCellsMode

Members

Name	Description
ShiftCellsDown	When inserting new cells in a worksheet, other cells in the same column are shifted down.
ShiftCellsRight	When inserting new cells in a worksheet, other cells in the same row are shifted to the right.
EntireRow	Entire rows are inserted above the specified cells.
EntireColumn	Entire columns are inserted to the left of the specified cells.

Remarks

The InsertCellsMode enumeration values are used by the Worksheet.InsertCells method. For details, see the How to: Insert a Cell or Cell Range and How to: Add a New Row or Column to a Worksheet examples.