Copying Cells vs Duplicating Copied Cells

1. Overview

The following Copy commands are available on the Edit menu.

2. Copy Commands

2.1 Edit > Copy

This is the standard copy command. It copies:

Subsequent copied native data can be accessed via the menu attached to the Paste button. The copy/paste level can be changed in Settings > Options; the default buffer size is 5.

When pasting, you only need to point to the top‑left cell of the target location. If you select a larger range before pasting, GS-Calc attempts to duplicate the copied source data within that selection only:

* *

2.2 Edit > Copy Values

Same as Copy, except that for cells containing formulas it copies their values instead of formulas.

2.3 Edit > Copy Width Options

Extends Copy with parameters typically used for text data/files:

You can save specific settings as predefined named parameter sets in the dialog box and select them with a single click.

2.4 Edit > Copy As HTML

Copies a range of cells as HTML code. The copied HTML can be pasted directly into HTML content in other applications as one continuous block.

In web browsers, the HTML looks the same as in the worksheet window, including styles and formatting, except for text rotation. For the “accounting” numeric style, you must use a fixed‑width font (e.g., Courier New) in GS-Calc for the related cells.

2.5 Edit > Copy As Image To

Copies selected data to an image file (jpg/png/gif/bmp/tiff).

2.6 Edit > Copy To PDF

Copies the selection (range or object/chart) to a PDF file.

2.7 Edit > Copy As Location

Creates and copies (as text) a reference to the current cell/selection and automatically adds it to:

2.8 Edit > Copy As Worksheet Hyperlink

Creates and copies (as text) a hyperlink to the current cell/selection. It prefixes the text with the hyperlink protocol name and instructs GS-Calc to set the hyperlink cell format for the cells where you paste it.

Clicking such a hyperlink cell jumps to and selects the specified cell/range. To move back to the clicked cell, use the toolbar bookmark Back button.

3. Paste Commands

3.1 Edit > Paste

Pastes copied data. If both native data and Clipboard data are available, copied native data take precedence.

3.2 Edit > Paste without Styles

Pastes copied native data without styles or formatting.

3.3 Edit > Paste As Text

Pastes available data (including numbers and formulas) as text strings.

3.4 Edit > Paste with Options

Pastes text data using definable parameters typically used for text data/files:

3.5 Edit > Paste Image

If image data are available, this command pastes that image.

3.6 Edit > Insert Copied Cells

Works similarly to Paste, except that: