PasteOptions

PasteOptions class

Represents the paste special options.

class PasteOptions;

Constructors

Name	Description
constructor()	Default Constructor.

Methods

Method	Description
getPasteType()	The paste special type.
setPasteType(PasteType)	The paste special type.
getSkipBlanks()	Indicates whether skips blank cells.
setSkipBlanks(boolean)	Indicates whether skips blank cells.
getOnlyVisibleCells()	True means only copying visible cells.
setOnlyVisibleCells(boolean)	True means only copying visible cells.
getTranspose()	True to transpose rows and columns when the range is pasted. The default value is False.
setTranspose(boolean)	True to transpose rows and columns when the range is pasted. The default value is False.
getOperationType()	Gets and sets the operation type when pasting range.
setOperationType(PasteOperationType)	Gets and sets the operation type when pasting range.
getIgnoreLinksToOriginalFile()	Ingore links to the original file.
setIgnoreLinksToOriginalFile(boolean)	Ingore links to the original file.
isNull()	Checks whether the implementation object is null.

constructor()

Default Constructor.

constructor();

getPasteType()

The paste special type.

getPasteType() : PasteType;

Returns

PasteType

setPasteType(PasteType)

The paste special type.

setPasteType(value: PasteType) : void;

Parameters:

Parameter	Type	Description
value	PasteType	The value to set.

getSkipBlanks()

Indicates whether skips blank cells.

getSkipBlanks() : boolean;

setSkipBlanks(boolean)

Indicates whether skips blank cells.

setSkipBlanks(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getOnlyVisibleCells()

True means only copying visible cells.

getOnlyVisibleCells() : boolean;

setOnlyVisibleCells(boolean)

True means only copying visible cells.

setOnlyVisibleCells(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getTranspose()

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

getTranspose() : boolean;

setTranspose(boolean)

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

setTranspose(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getOperationType()

Gets and sets the operation type when pasting range.

getOperationType() : PasteOperationType;

Returns

PasteOperationType

setOperationType(PasteOperationType)

Gets and sets the operation type when pasting range.

setOperationType(value: PasteOperationType) : void;

Parameters:

Parameter	Type	Description
value	PasteOperationType	The value to set.

getIgnoreLinksToOriginalFile()

Ingore links to the original file.

getIgnoreLinksToOriginalFile() : boolean;

setIgnoreLinksToOriginalFile(boolean)

Ingore links to the original file.

setIgnoreLinksToOriginalFile(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

isNull()

Checks whether the implementation object is null.

isNull() : boolean;