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:
- native worksheet data to the cyclic GS-Calc copy/paste buffer,
- plain text to the Clipboard,
- an image/PNG representation of the copied range or objects (e.g., charts).
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:
- separators,
- fixed column widths,
- quoting symbol,
- whether copied data should be formatted,
- text encoding.
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:
- the list of references used in various Insert > … formula composers,
- the Go To list on the toolbar (for navigation or selection of ranges).
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:
- separators,
- fixed column widths,
- quoting symbol,
- escaping symbol,
- text conversion types,
- text encoding,
- saving cell styles detected in formatted numbers and dates.
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:
- columns in the target area are shifted left,
- rows in the target area are shifted down.