PasteOptions

PasteOptions class

Represents the paste special options.

class PasteOptions;

Name	Description
constructor()	Default Constructor.

Property	Type	Description
pasteType	PasteType	The paste special type.
shiftFormulasOfShapes	boolean	Indicates whether to shift formulas of the shapes when copying ranges.
skipBlanks	boolean	Indicates whether skips blank cells.
keepOldTables	boolean	Keeps the tables in the destination range.
onlyVisibleCells	boolean	True means only copying visible cells.
transpose	boolean	True to transpose rows and columns when the range is pasted. The default value is False.
operationType	PasteOperationType	Gets and sets the operation type when pasting range.
ignoreLinksToOriginalFile	boolean	Ingore links to the original file.

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;