Contents |
Copy columns with format & headers
Updated in Origin 8.1 SR2
1. colcopy irng:=[Book1]Sheet1!Col(1) orng:=[Book1]Sheet1!Col(2);
2. colcopy irng:=[Book1]Sheet1!Col(1) orng:=[Book1]Sheet1!Col(3);
3. colcopy irng:=col(A) orng:=col(B) data:=1 lname:=1 units:=1 comments:=1 para:=1;
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Source Columns | irng |
Input Range | | Specify the source column from which data/format is copied. |
| Destination Columns | orng |
Output Range | | Specify the destination column to which the data/format is pasted.
See the syntax here. |
| Copy Data | data |
Input int | | Specify whether or not to copy data. |
| Copy Format | format |
Input int | | Specify whether or not to copy format. |
| Long Name | lname |
Input int | | Specify whether or not to copy Long Name. |
| Units | units |
Input int | | Specify whether or not to copy Units. |
| Comments | comments |
Input int | | Specify whether or not to copy Comments. |
| Parameters | para |
Input int | | Specify whether or not to copy Parameters. |
| User-Defined | usrdef |
Input int | | Specify whether or not to copy user-defined parameters |
This function is used to copy columns with format & headers to another columns.