TdxSpreadSheetCellsModification Enum

Enumerates options that define how cell insert and delete operations affect adjacent cells.

Declaration

TdxSpreadSheetCellsModification = (
    cmShiftCellsHorizontally,
    cmShiftCellsVertically,
    cmShiftColumns,
    cmShiftRows
);

Members

Name
cmShiftCellsHorizontally
cmShiftCellsVertically
cmShiftColumns
cmShiftRows

Remarks

Different cells modification operations produce different effects for the same options:

Value	Insert Cells Operations	Delete Cells Operations
cmShiftCellsHorizontally	The value corresponds to the “Insert” dialog’s “Shift cells right” option. A cell modification operation shifts right the same-sized portion of all rows that intersect the target cell range to free up its area. Every shifted row starts with the range’s leftmost cell.	The value corresponds to the “Delete” dialog’s “Shift cells left” option. A cell modification operation shifts left the same-sized portion of all rows that intersect the deleted cell range to occupy its area. Every shifted row starts with a cell that follows the deleted cell range’s rightmost cell.
cmShiftCellsVertically	The value corresponds to the “Insert” dialog’s “Shift cells down” option. A cell modification operation shifts down the same-sized portion of all columns that intersect the target cell range to free up its area. Every shifted column starts with the range’s top cell.	The value corresponds to the “Delete” dialog’s “Shift cells up” option. A cell modification operation shifts up the same-sized portion of all columns that intersect the deleted cell range to occupy its area. Every shifted column starts with a cell that follows the deleted cell range’s bottom cell.
cmShiftColumns	The value corresponds to the “Entire column” option in both the “Insert” and “Delete” dialogs.
	A cell modification operation shifts a number of columns right to free up all columns that intersect the target cell range, starting with the column that intersects the range’s leftmost cell.	A cell modification operation shifts a number of columns left to occupy the continuous space that intersects the deleted cell range.
cmShiftRows	The value corresponds to the “Entire row” option in both the “Insert” and “Delete” dialogs.
	A cell modification operation shifts a number of rows down to free up all rows that intersect the target cell range, starting with the row that intersects the range’s top cell.	A cell modification operation shifts a number of rows top to occupy the continuous space that intersects the deleted cell range.

A Table View worksheet’s InsertCells and DeleteCells procedures accept a TdxSpreadSheetCellsModification value as the AModification parameter. In addition, the cells modification dialog form’s CellsModification references the TdxSpreadSheetCellsModification type.