Spread 8.0 Documentation
ClipboardPaste Method
Support Options
ActiveX Reference > ActiveX Methods > ClipboardPaste Method

Glossary Item Box

ClipboardPaste Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Pastes the Clipboard contents into the active cell or block of cells.

Syntax

C++

void CSpreadSheet::ClipboardPaste( );

Visual Basic

fpSpread1.ClipboardPaste( )

Remarks

The ClipboardCopy, ClipboardCut, and ClipboardPaste methods use a tab-delimited text format for data transferred to and from the Clipboard. Only data is transferred to and from the Clipboard; cell properties, such as cell type or data formatting, are not copied, cut, or pasted.

When pasting data from the clipboard, if a block of cells is selected, the block is replaced with the Clipboard contents. If the contents of the Clipboard are bigger than the selected block, the contents of the Clipboard are truncated at the edge of the block.

If no cells are selected, the contents of the Clipboard are pasted into the sheet starting at the active cell. The contents of the cells to the right of and below the active cell are replaced by the contents of the Clipboard.

This method is called for the active sheet.

By default, row headers can be included in Clipboard operations. You can change how row headers are handled in Clipboard operations by setting the ClipboardOptions property.

Return Type

None

See Also

ClipboardOptions, Sheet properties

ClipboardCopy, ClipboardCut methods

DLL Correspondence

SSClipboardPaste function

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.