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

PasteType

Enum Class PasteType

java.lang.Object
java.lang.Enum<PasteType>
com.grapecity.documents.excel.PasteType
All Implemented Interfaces:
Serializable, Comparable<PasteType>, Constable
public enum PasteType extends Enum<PasteType>
Specifies the type of content to paste during a range copy operation.

Used with IRange.copy(IRange,PasteOption) or PasteOption.setPasteType(java.util.EnumSet) to control which aspects of the source range are pasted to the destination. Multiple values can be combined using EnumSet.


 worksheet.getRange("A1:B2").setValue(new Object[][] {
     {"Name", "Price"},
     {"Apple", 1.99}
 });
 worksheet.getRange("A1:B1").getFont().setBold(true);
 // Copy only values (without formatting) to another range
 PasteOption option = new PasteOption();
 option.setPasteType(EnumSet.of(PasteType.Values));
 worksheet.getRange("A1:B2").copy(worksheet.getRange("D1"), option);

  • Enum Constant Details

    • Values

      public static final PasteType Values
      Specifies to only paste cell values.

    • Formulas

      public static final PasteType Formulas
      Specifies to only paste cell formulas.

    • Formats

      public static final PasteType Formats
      Specifies to only paste formats.

    • NumberFormats

      public static final PasteType NumberFormats
      Specifies to only paste number formats.

    • ColumnWidths

      public static final PasteType ColumnWidths
      Specifies to only paste column widths.

    • RowHeights

      public static final PasteType RowHeights
      Specifies to only paste row heights.

  • Field Details

    • Default

      public static final EnumSet<PasteType> Default
      Specifies to paste all data except RowHeights and ColumnWidths.

  • Method Details

    • values

      public static PasteType[] 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 PasteType 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