Enumeration: ClipboardPasteOptions

Spread.Sheets.ClipboardPasteOptions

Specifies what data is pasted from the Clipboard.

example

//This example uses the ClipboardPasteOptions enumeration.
activeSheet.options.clipBoardOptions = GC.Spread.Sheets.ClipboardPasteOptions.values;

Table of contents

Enumeration members

• all
• allAndColumnWidth
• columnWidths
• comments
• formatting
• formulas
• formulasAndFormatting
• formulasAndNumberFormatting
• noBorder
• usingSourceTheme
• validation
• values
• valuesAndFormatting
• valuesAndNumberFormatting
• valuesAndSourceFormatting

Enumeration members

all

• all = 0

Pastes all data objects, including values, formatting, and formulas.

allAndColumnWidth

• allAndColumnWidth = 14

Pastes all data objects and keep column width

columnWidths

• columnWidths = 10

Pastes the column widths.

comments

• comments = 6

Pastes only comments.

formatting

• formatting = 2

Pastes only formatting.

formulas

• formulas = 3

Pastes only formulas.

formulasAndFormatting

• formulasAndFormatting = 5

Pastes formulas and formatting.

formulasAndNumberFormatting

• formulasAndNumberFormatting = 11

Paste formulas and number formatting options

noBorder

• noBorder = 9

Pastes all cell contents except borders.

usingSourceTheme

• usingSourceTheme = 8

Paste all data object and apply source theme to style/

validation

• validation = 7

Paste only validation.

values

• values = 1

Pastes only values.

valuesAndFormatting

• valuesAndFormatting = 4

Pastes values and formatting.

valuesAndNumberFormatting

• valuesAndNumberFormatting = 12

Paste values and number formatting options

valuesAndSourceFormatting

• valuesAndSourceFormatting = 13

Paste values and source formatting options