PasteOptions

PasteOptions class

Represents the paste special options.

class PasteOptions;

Default Constructor.

constructor();

The paste special type.

pasteType : PasteType;

Indicates whether to shift formulas of the shapes when copying ranges.

shiftFormulasOfShapes : boolean;

Indicates whether skips blank cells.

skipBlanks : boolean;

Keeps the tables in the destination range.

keepOldTables : boolean;

True means only copying visible cells.

onlyVisibleCells : boolean;

True to transpose rows and columns when the range is pasted. The default value is False.

transpose : boolean;

Gets and sets the operation type when pasting range.

operationType : PasteOperationType;

Ingore links to the original file.

ignoreLinksToOriginalFile : boolean;