PasteOptions
Contents
[
Hide
]PasteOptions class
Represents the paste special options.
class PasteOptions;
Constructors
| Name | Description |
|---|---|
| constructor() | Default Constructor. |
Properties
| Property | Type | Description |
|---|---|---|
| pasteType | PasteType | The paste special type. |
| 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. |
constructor()
Default Constructor.
constructor();
pasteType
The paste special type.
pasteType : PasteType;
skipBlanks
Indicates whether skips blank cells.
skipBlanks : boolean;
keepOldTables
Keeps the tables in the destination range.
keepOldTables : 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;