4.4.11 Copy Columns to New Destinationscopy-columns
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, or copy masked pattern, 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 clicking on a column and select Copy Columns to... from the shortcut menu.
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.
|
|