PasteOptions
Contents
[
Hide
]PasteOptions class
Represents the paste special options.
Constructors
| Name | Description |
|---|---|
| PasteOptions |
Properties
| Name | Type | Description |
|---|---|---|
| PasteType | int | The paste special type. The value of the property is PasteType integer constant. |
| ShiftFormulasOfShapes | boolean | |
| SkipBlanks | boolean | Indicates whether skips blank cells. |
| KeepOldTables | boolean | |
| 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 | int | Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant. |
| IgnoreLinksToOriginalFile | boolean | Ingore links to the original file. |
PasteOptions()
PasteOptions.PasteType property
The paste special type. The value of the property is PasteType integer constant.
Type: int
PasteOptions.ShiftFormulasOfShapes property
Type: boolean
PasteOptions.SkipBlanks property
Indicates whether skips blank cells.
Type: boolean
PasteOptions.KeepOldTables property
Type: boolean
PasteOptions.OnlyVisibleCells property
True means only copying visible cells.
Type: boolean
PasteOptions.Transpose property
True to transpose rows and columns when the range is pasted. The default value is False.
Type: boolean
PasteOptions.OperationType property
Gets and sets the operation type when pasting range. The value of the property is PasteOperationType integer constant.
Type: int
PasteOptions.IgnoreLinksToOriginalFile property
Ingore links to the original file.
Type: boolean