4.4.11 Copy Columns to New Destinations

Copy-paste is a straightforward way to copy data in one or more columns to new columns, but in order to copy column data format or labels or to copy an applied data filter, you need to use the colcopy X-Function. In the GUI, you can access this X-Function by selecting Worksheet:Copy Columns to:Open Dialog... from the main menu (or right click on a column and select Copy Columns to... from the shortcut menu).

Copy Columns to Dialog.png

The following table summarizes the dialog box controls:

Recalculate Specify the Recalculate Mode for this operation
Source Column(s) Specify the Input Data.
Destination Column(s) Specify where to output pasted data
Copy Data Specify whether to copy data or not.
Copy Sampling Intervals Specify whether to copy the Sampling Intervals or not.
Ignore Hidden Rows Specify whether to ignore hidden rows.
Copy Mask Specify whether to copy the masking status of the data points or not.
Copy Format Specify whether to copy the column format and all cell format of data or not.
Copy Labels Specify whether to copy the column label rows.
Sort Output Sort output by values in a reference column. Default is unsorted. Opt to sort by ascending or descending order values in a named Reference Column.

If the Recalculate Mode for the Copy Columns to operation is set to Auto or Manual, a green lock icon will be set in the destination column(s). Left-clicking on the lock opens a menu. If the destination column(s) are not in the same worksheet as the source columns, there will be three worksheet filter related options in this menu.

Initially, only the Worksheet Filters: Lock menu item will be available. In this state, a change to the filter condition of the source worksheet will trigger an update to the data in the destination column(s). If you click Worksheet Filters: Lock once, the destination worksheet columns become locked, and changes to the filter condition of the source worksheet will no longer trigger an update to the destination column(s).

Worksheet Filters:Lock

When this option is selected, the result will be locked from data filter condition change of source column(s). So when the filter condition in the source column worksheet is changed, it will not trigger update in the destination column(s).

Worksheet Filters:Reload

This option is only available when the Worksheet Filter: Lock has been selected already. It reloads the data filter condition from the source column(s) to the destination column(s). i.e. after you changed the data filter condition of the source column(s), click this option to trigger the auto update of the locked destination column(s), so that the same filter condition applies to destination column(s) as well.

Worksheet Filters:Push Back

This option is only available when the Worksheet Filter: Lock has been selected already. It pushes the initial data filter condition back to the source column(s). i.e. after you changed the data filter condition of the source worksheet, click this option and the most recent data filter condition that has been applied from source column(s) to destination column(s) will be pushed back to the source worksheet. Note that if you applied a data filter directly to destination column(s), it will not be pushed back to source.