DeleteMode Enum

Specifies how to delete cells from a worksheet.

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

Declaration

C#
VB.NET

public enum DeleteMode

Public Enum DeleteMode

Members

Name	Description
`ShiftCellsLeft`	When deleting cells from a worksheet, other cells in the same row are shifted to the left.
`ShiftCellsUp`	When deleting cells from a worksheet, other cells in the same column are shifted up.
`EntireRow`	Entire rows containing the specified cell range are deleted.
`EntireColumn`	Entire columns containing the specified cell range are deleted.

Remarks

The DeleteMode enumeration values are used by the Worksheet.DeleteCells method. For details, refer to the How to: Delete a Cell or Range of Cells and How to: Delete a Row or Column from a Worksheet examples.

The following code snippets (auto-collected from DevExpress Examples) contain references to the DeleteMode enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#
VB.NET

spreadsheet-document-api-examples-part1/CS/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.cs#L75

// Delete a row that contains the "B2" cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);
#endregion #DeleteRows

wpf-spreadsheetcontrol-api-part-1-e4938/CS/SpreadsheetControl_WPF_API/SpreadsheetActions/RowAndColumnActions.cs#L82

// Delete a row that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);
#endregion #DeleteRows

winforms-spreadsheetcontrol-api-e4655/CS/SpreadsheetControl/SpreadsheetActions/RowAndColumnActions.cs#L81

// Delete a row that contains the "B2" cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);
#endregion #DeleteRows

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/CS/DataImportExample/Form1.cs#L17

Worksheet worksheet = spreadsheetControl1.Document.Worksheets[0];
worksheet.DeleteCells(worksheet.Cells, DeleteMode.ShiftCellsLeft);
ImportDataTable();

spreadsheet-document-api-examples-part1/VB/SpreadsheetExamples/SpreadsheetActions/RowAndColumnActions.vb#L69

            ' Delete a row that contains the "B2" cell.
            worksheet.DeleteCells(worksheet.Cells("B2"), DeleteMode.EntireRow)
#End Region  ' #DeleteRows

wpf-spreadsheetcontrol-api-part-1-e4938/VB/SpreadsheetControl_WPF_API/SpreadsheetActions/RowAndColumnActions.vb#L84

                ' Delete a row that contains the "B2"cell.
                worksheet.DeleteCells(worksheet.Cells("B2"), DeleteMode.EntireRow)
'                #End Region ' #DeleteRows

winforms-spreadsheetcontrol-api-e4655/VB/SpreadsheetControl/SpreadsheetActions/RowAndColumnActions.vb#L84

                ' Delete a row that contains the "B2" cell.
                worksheet.DeleteCells(worksheet.Cells("B2"), DeleteMode.EntireRow)
'                #End Region ' #DeleteRows

how-to-import-data-to-worksheet-cells-from-different-data-sources-and-use-tables-e4751/VB/DataImportExample/Form1.vb#L19

Dim worksheet As Worksheet = spreadsheetControl1.Document.Worksheets(0)
worksheet.DeleteCells(worksheet.Cells, DeleteMode.ShiftCellsLeft)
ImportDataTable()

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

.NET Subscription

Common Tools

Controls

Tools

Controls and Extensions

Tools

Maintenance Mode

DeleteMode Enum

Declaration

Members

Remarks

DeleteMode Enum

Declaration

Members

Remarks

Related GitHub Examples