GrapeCity.Documents.Excel.DeleteShiftDirection

DeleteShiftDirection Enum

Specifies how to shift cells to replace deleted cells.

Used with the Delete(DeleteShiftDirection) method to control the direction in which remaining cells move after a deletion.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum DeleteShiftDirection

Public Enum DeleteShiftDirection

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {1, 2, 3},
    {4, 5, 6},
    {7, 8, 9}
};
worksheet.Range["B2"].Delete(DeleteShiftDirection.Left);

Fields

Name	Description
Auto	Specifies that the shift direction is based on the shape of the range.
Left	Specifies that cells are shifted to the left.
Up	Specifies that cells are shifted up.