Enum XLTransposeOptions
A behavior of extra outside cells for transpose operation. The option is meaningful only for transposition of non-squared ranges, because squared ranges can always be transposed without effecting outside cells.
public enum XLTransposeOptions
- Extension Methods
Fields
MoveCells = 0Shift cells of the smaller side to its direction so there is a space to transpose other side (e.g. if A1:C5 range is transposed, move D1:XFD5 are moved 2 columns to the right).
ReplaceCells = 1Data of the cells are replaced by the transposed cells.