Moving, Copying, and Pasting

You can copy, move, and paste data within and between worksheets and workbooks. When you copy data from a cell in a worksheet, you copy more than just text. Information stored in a worksheet includes many different types of data, including:

• Formulas. The result of the formula establishes the value in a cell. Formulas are displayed in the formula bar when the cell is active.
• Values. The number or text displayed in a cell.
• Formats. How the cells and values are displayed, such as color settings or currency formatting applied to a number.

Using the Clipboards

Formula One for Java's own internal clipboard allows you to copy freely between worksheets and workbooks and maintain all types of data. However, when you copy between Formula One for Java and other software packages using the system clipboard, which stores only text and formatting information, you may lose cell reference and other data.

Pasting Ranges

If you select a paste-to range, rather than a cell, as a paste area, Formula One for Java behaves differently based on the size of the range selected. If you select a paste-to range smaller than the copied range, only the cells that fit are pasted -- no cells are pasted outside the selected paste-to range. If you select a paste-to range larger than the copied cells, Formula One for Java pastes multiple copies of the copied range in a tile pattern to fill in the copy-to range.

Using Dragging to Move, Copy, and Paste

This section discusses how to:

• copy a selection of cells to the right or down using dragging
• drag-and-drop a selection to copy or move it

Using Dragging to Copy

Copy data in the active cell to the right or down by dragging the copy handle of the active cell. The copy handle is the small square in the lower right corner of the active cell. When you copy data using the copy handle, the pointer changes to a crosshair. The following illustrations show how to copy by dragging.

You can also copy a selected range in a worksheet. If an autofill list is defined for the data in the range, the data is copied using the autofill list, as shown in the following illustration. For more information on autofill lists, see Using Autofill Lists.

Note You cannot drag to copy cells and ranges if the Fill Ranges by Dragging checkbox is unchecked on the Edit tab of the Format Sheet dialog. For more information, see Controlling Worksheet Usage.

Using Drag-and-Drop to Move or Copy

The following steps describe how to move or copy a selection using Formula One for Java's drag-and-drop.

To move or copy a selection using drag-and-drop:

1. Select the cells that contain the data or object you want to move or copy.
2. Position the pointer on the border of the selection.
3. Move the selection by holding down the mouse button and dragging-and-dropping the selection to the new location. You can also copy the selection by holding down the CTRL key and dragging-and-dropping the selection to the new location. An outline of the selection moves as you drag the pointer.

   

4. When the pointer is at the new location, release the mouse button.

A copy of the original selection remains in place if you hold down the CTRL key.

Note You cannot drag and drop to copy cells and ranges if the Move Ranges by Dragging checkbox is unchecked on the Edit tab of the Format Sheet dialog. For more information, see Controlling Worksheet Usage.

Using The Toolbar to Move, Copy, and Paste

To move or copy cell data using the toolbar:

1. Select the cells that you want to cut or copy.
2. Click on the cut or the copy button.
3. Select the new location.
4. Click on the paste button.

To copy formatting from a cell or range and apply that formatting to another cell or range:

1. Select the cells whose format you want to copy.
2. Click on the copy format button.
3. Click on the cell or cell range where you want to apply the formatting.

Using Menu Commands to Move, Copy, and Paste

Use menu commands to handle copying and moving if the original and the new locations are far apart on the same worksheet or you are moving selections between workbooks, worksheets, or applications. Also use menu commands when you don't want to paste all cell attributes to the new location. Using menu commands, Formula One for Java also allows you to choose whether to paste formulas, values, and formats. Formula One for Java allows you to copy formatting from a cell or range and apply that formatting to another cell or range.

This section describes how to use menu commands to:

• move or copy data from cell(s) to cell(s)
• copy formatting from cell(s) to cell(s)
• paste individual attributes of a selection to another location.

To move or copy all attributes of a selection:

1. Select the cells that you want to cut or copy.
2. Select Edit > Cut to cut the selection; Edit > Copy to copy the selection.
3. Select the upper left cell of the range in which you want to move or paste the selection.
4. Select Edit > Paste.

   The selection that was copied or cut is pasted with all cell attributes.

To paste formulas, values, and/or formats:

1. Select the cells that you want to cut or copy.
2. Select Edit > Cut to cut the selection; Edit > Copy to copy the selection.
3. Select the upper left cell of the area or highlight a range where you want to paste the copied cell formulas, values, and/or formats.
4. Select Edit > Paste Special.
5. The Paste Special dialog box is displayed as shown in the following illustration:

   

6. Click in the checkboxes for the attributes you want to paste.
7. Click OK.

To copy only the formatting of a selection and apply it to a cell or range:

1. Select the cells that contain the formatting that you want to apply.
2. Select Edit > Copy Cell Format.
3. Select the cell or range to which you want to apply the formatting.

   The formatting is applied.