Click or drag to resize

Copy/paste of worksheet data

Previous section: Selection of columns and/or rows in a worksheet


Copying of worksheet data is easy: just select the portion of data you want to copy in your worksheet, and then press CTRL-C or choose Edit→Copy from the main menu. The data are copied to the clipboard.

To paste data into another worksheet (or the same worksheet) press CTRL-V or choose Edit→Paste from the main menu. Pasting is a more subtle operation, and the result depends on which columns/rows/property columns are currently selected in the destination worksheet. The following list is processed in order to decide where to paste the data into the destination worksheet:

  1. If nothing is selected: the new data are pasted to the right of the last data column of the worksheet

  2. If some data columns are selected and the number of selected data columns matches the number of data columns to paste: paste the clipboard data into the selected data columns. If in addition data rows are selected, then first fill the selected data rows, and, if there are more data rows on the clipboard, fill the data rows after the last selected data row.

  3. If some data columns are selected and the number of selected data columns matches the number of data rows to paste: paste the clipboard data transposed into the selected data columns. Transposing means that data columns become data rows and vice versa. If in addition data rows are selected, then first fill the selected data rows, and if there are still more data available, fill the data rows after the last selected data row.

  4. If any data rows are selected and the number of selected data rows matches the number of data rows to paste: paste the clipboard data into the selected data rows. If in addition data columns are selected, then first fill the data into the selected data columns, and if there are still more data columns available, fill the columns to the right of the last selected data column.

  5. If any data rows are selected and the number of selected data rows matches the number of data columns to paste: paste the clipboard transposed data into the selected data rows. If in addition data columns are selected, then first fill the data into the selected data columns, and if there are still more data columns available, fill the columns to the right of the last selected data column.

  6. If any property columns are selected and the number of selected property columns matches the number of data columns to paste: paste the clipboard data into the selected property columns. If in addition any data columns are selected, then put the data only in those property cells, which are selected both by the property column selection and the data column selection.

  7. If any data columns are selected (non-exact match): paste into the selected data columns, and, if there are more columns on the clipboard, paste them to the right of the rightmost selected data column. If in addition data rows are selected, then first fill the selected data rows, and, if there are more data rows on the clipboard, fill the data rows after the last selected data row.

  8. If any data rows are selected (non-exact match): past the clipboard data rows into the selected data rows, and, if there are more rows to paste, paste them below the lowest selected data row. If in addition data columns are selected, then first fill the data into the selected data columns, and if there are still more data columns available, fill the columns to the right of the last selected data column.


Next section: Importing ASCII data