Spread 8.0 Documentation
SSClipboardPaste Function
Support Options
DLL Reference > DLL Functions > SSClipboardPaste Function

Glossary Item Box

SSClipboardPaste Function


See Also    ActiveX

Applies To

fpSpread DLL control

Description

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

Syntax

C

BOOL SSClipboardPaste(HWND hWnd);

C++

BOOL TSpread::ClipboardPaste(void);

Parameters

The following parameter is available:

Parameter Description
hWnd Window handle of the fpSpread control

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

The SSClipboardCopy, SSClipboardCut, and SSClipboardPaste functions 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.

By default, row headers can be included in Clipboard operations. You can change how row headers are handled in Clipboard operations by calling the SSSetClipboardOptions function.

Return Value

TRUE if the function completes successfully; FALSE otherwise.

See Also

Copying Data Using the Clipboard
Moving Data Using the Clipboard

SSClipboardCopy, SSClipboardCut, SSGetClipboardOptions, SSSetClipboardOptions, SSSetSheet functions

ActiveX Correspondence

ClipboardPaste method

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