Excel.ChangeDirectionState interface

Represents the direction that existing or remaining cells in a worksheet will shift when cells are inserted into or deleted from a worksheet.

Remarks

[ API set: ExcelApi 1.14 ]

Properties

deleteShiftDirection

Represents the direction (such as up or to the left) that the remaining cells will shift when a cell or cells are deleted. Note: insertShiftDirection and deleteShiftDirection are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined.

insertShiftDirection

Represents the direction (such as down or to the right) that the existing cells will shift when a new cell or cells are inserted. Note: insertShiftDirection and deleteShiftDirection are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined.

Property Details

deleteShiftDirection

Represents the direction (such as up or to the left) that the remaining cells will shift when a cell or cells are deleted. Note: insertShiftDirection and deleteShiftDirection are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined.

deleteShiftDirection: Excel.DeleteShiftDirection | "Up" | "Left";

Property Value

Excel.DeleteShiftDirection | "Up" | "Left"

Remarks

[ API set: ExcelApi 1.14 ]

insertShiftDirection

Represents the direction (such as down or to the right) that the existing cells will shift when a new cell or cells are inserted. Note: insertShiftDirection and deleteShiftDirection are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined.

insertShiftDirection: Excel.InsertShiftDirection | "Down" | "Right";

Property Value

Excel.InsertShiftDirection | "Down" | "Right"

Remarks

[ API set: ExcelApi 1.14 ]