[]
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;
• all = 0
Pastes all data objects, including values, formatting, and formulas.
• allAndColumnWidth = 14
Pastes all data objects and keep column width
• columnWidths = 10
Pastes the column widths.
• comments = 6
Pastes only comments.
• formatting = 2
Pastes only formatting.
• formulas = 3
Pastes only formulas.
• formulasAndFormatting = 5
Pastes formulas and formatting.
• formulasAndNumberFormatting = 11
Paste formulas and number formatting options
• noBorder = 9
Pastes all cell contents except borders.
• usingSourceTheme = 8
Paste all data object and apply source theme to style/
• validation = 7
Paste only validation.
• values = 1
Pastes only values.
• valuesAndFormatting = 4
Pastes values and formatting.
• valuesAndNumberFormatting = 12
Paste values and number formatting options
• valuesAndSourceFormatting = 13
Paste values and source formatting options