[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

InsertShiftDirection

Enum Class InsertShiftDirection

java.lang.Object
java.lang.Enum<InsertShiftDirection>
com.grapecity.documents.excel.InsertShiftDirection
All Implemented Interfaces:
Serializable, Comparable<InsertShiftDirection>, Constable
public enum InsertShiftDirection extends Enum<InsertShiftDirection>
Specifies the direction to shift cells when inserting a cell or a range of cells into a worksheet.

Used with the IRange.insert(InsertShiftDirection) method to control whether existing cells are shifted down or to the right to make room for the newly inserted cells.


 worksheet.getRange("A1:C3").setValue(new Object[][] {
     {1, 2, 3},
     {4, 5, 6},
     {7, 8, 9}
 });
 worksheet.getRange("B2").insert(InsertShiftDirection.Down);
 worksheet.getRange("C2").insert(InsertShiftDirection.Right);

  • Enum Constant Details

    • Auto

      public static final InsertShiftDirection Auto
      Specifies that the shift direction is decided based on the shape of the range.

    • Down

      public static final InsertShiftDirection Down
      Specifies to shift cells down.

  • Method Details

    • values

      public static InsertShiftDirection[] values()
      Returns an array containing the constants of this enum class, in the order they are declared.
      Returns:
      an array containing the constants of this enum class, in the order they are declared

    • valueOf

      public static InsertShiftDirection valueOf(String name)
      Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)
      Parameters:
      name - the name of the enum constant to be returned.
      Returns:
      the enum constant with the specified name
      Throws:
      IllegalArgumentException - if this enum class has no constant with the specified name
      NullPointerException - if the argument is null