Spread 8.0 Documentation
Moving Data Using the Clipboard
Support Options
User's Guide > Working with the Control > Working with Data > Moving Data > Moving Data Using the Clipboard

Glossary Item Box

Moving Data Using the Clipboard


Overview

You can cut unformatted data from a selected cell or block of cells to the Clipboard, and paste unformatted data from the Clipboard into a selected cell or block of cells. Use the standard Clipboard keys to move data to (Ctrl+X) and paste data from (Ctrl+V) the Clipboard.

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, column and row headers are included when data is cut and pasted and the pasted headers overwrite the selected headers. You can specify that column and row headers are not included when data is cut and column and row headers are not overwritten when data is pasted.

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