PasteOptions

PasteOptions class

Represents the paste special options.

class PasteOptions;

Constructors

Constructor	Description
constructor()	Default Constructor.

Properties

Property	Type	Description
pasteType	PasteType	The paste special type.
skipBlanks	boolean	Indicates whether skips blank cells.
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.

Methods

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

constructor()

Default Constructor.

constructor();

pasteType

The paste special type.

pasteType : PasteType;

skipBlanks

Indicates whether skips blank cells.

skipBlanks : boolean;

onlyVisibleCells

True means only copying visible cells.

onlyVisibleCells : boolean;

transpose

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

transpose : boolean;

operationType

Gets and sets the operation type when pasting range.

operationType : PasteOperationType;

ignoreLinksToOriginalFile

Ingore links to the original file.

ignoreLinksToOriginalFile : boolean;

getPasteType()

@deprecated. Please use the ‘pasteType’ property instead. The paste special type.

getPasteType() : PasteType;

Returns

PasteType

setPasteType(PasteType)

@deprecated. Please use the ‘pasteType’ property instead. The paste special type.

setPasteType(value: PasteType) : void;

Parameters:

Parameter	Type	Description
value	PasteType	The value to set.

getSkipBlanks()

@deprecated. Please use the ‘skipBlanks’ property instead. Indicates whether skips blank cells.

getSkipBlanks() : boolean;

setSkipBlanks(boolean)

@deprecated. Please use the ‘skipBlanks’ property instead. Indicates whether skips blank cells.

setSkipBlanks(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getOnlyVisibleCells()

@deprecated. Please use the ‘onlyVisibleCells’ property instead. True means only copying visible cells.

getOnlyVisibleCells() : boolean;

setOnlyVisibleCells(boolean)

@deprecated. Please use the ‘onlyVisibleCells’ property instead. True means only copying visible cells.

setOnlyVisibleCells(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getTranspose()

@deprecated. Please use the ’transpose’ property instead. True to transpose rows and columns when the range is pasted. The default value is False.

getTranspose() : boolean;

setTranspose(boolean)

@deprecated. Please use the ’transpose’ property instead. 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()

@deprecated. Please use the ‘operationType’ property instead. Gets and sets the operation type when pasting range.

getOperationType() : PasteOperationType;

Returns

PasteOperationType

setOperationType(PasteOperationType)

@deprecated. Please use the ‘operationType’ property instead. Gets and sets the operation type when pasting range.

setOperationType(value: PasteOperationType) : void;

Parameters:

Parameter	Type	Description
value	PasteOperationType	The value to set.

getIgnoreLinksToOriginalFile()

@deprecated. Please use the ‘ignoreLinksToOriginalFile’ property instead. Ingore links to the original file.

getIgnoreLinksToOriginalFile() : boolean;

setIgnoreLinksToOriginalFile(boolean)

@deprecated. Please use the ‘ignoreLinksToOriginalFile’ property instead. 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;