| Author |
 Topic  |
|
|
elalexi
1 Posts |
 Posted - 11/23/2017 : 12:55:13 PM
|
Hello
Origin Ver. and Service Release: originPro2016
Operating System: Windows10
I would like to link the columns' long names, comments and/or units of different worksheets, so that I can write the headers in one worksheet and this headers are automatically copied to worksheets in the same workbook and worksheets in other workbooks of my choice. Also if possible transpose the dataset from a column into comlumns' headers of the worksheets.
Thanks in advance,
Alex |
|
|
nick_n
Finland
125 Posts |
|
|
nick_n
Finland
125 Posts |
Posted - 11/24/2017 : 03:23:29 AM
|
...or just copy your comments, units etc and then paste as link (or paste link transpose) from context menu. BR,
Nikolay |
 |
|
|
arstern
USA
237 Posts |
Posted - 11/27/2017 : 12:50:52 PM
|
In addition to Nikolay suggestion, you can as well save your workbook as a template.
Documentation on creating a workbook template:
https://www.originlab.com/doc/Origin-Help/Wkbk-Saved-with-Template
1. To input your dataset from a column into transpose columns headers:
Right-click the header i.e. Long Name and Select User Parameters. Then select Insert -> Select User-Defined. Create a new parameter row.
Next Highlight your column that you want to transpose -> Right Click-> Select Copy. Within the new User-Defined parameter right, Rick-Click the first cell and select Paste Link Transpose.
2. With the worksheet formatted how you want - activate the worksheet -> Select File -> Save Template As...
Category lists UserDefined. For Template Name change to desire name, unless you want this to be your default workbook for all projects. Select ok.
This template will save your Long Name, Units, Comments, as well as the transpose column.
3. With new workbook activated -> Select Import Wizard. The Import Wizard Dialog will appear. Select desire file to open. Under Template -> Select new template created.
Select Next.
Within the bottom panel it will show your header and subheader from the file. If you have subheaders from that file input the number of header and subheaders in the Number of Main header lines (Exclude subheader lines). All headers will be shown in black.
This image is an example for removing headers from file:
Select Finish.
Hope this makes sense,
Aviel
OriginLab
|
|
|
| |
Topic |
|
|
|
Link Column Long Names, Comments and/or Units