new PasteOptions()

Methods

getIgnoreLinksToOriginalFile()

Ingore links to the original file.

getOnlyVisibleCells()

True means only copying visible cells.

getOperationType()

Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.

getPasteType()

The paste special type. The value of the property is PasteType integer constant.

getSkipBlanks()

Indicates whether skips blank cells.

getTranspose()

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

setIgnoreLinksToOriginalFile()

Ingore links to the original file.

setOnlyVisibleCells()

True means only copying visible cells.

setOperationType()

Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.

setPasteType()

The paste special type. The value of the property is PasteType integer constant.

setSkipBlanks()

Indicates whether skips blank cells.

setTranspose()

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