Hello,
In Set Column Values dialog, there is a Before Formula Scripts panel. By default it's not shown. You can click double arrow button to the right of OK button.
It supports full Labtalk control. In 8.0, we support range notation for user to specify col/range/worksheet in LabTalk.
Here is what you can do:
1. In Before Formula Scripts, type
range bb=[Book1]Sheet1!Col(B) //define a range variable bb which points col(B) of Sheet1 of Book1 window.
2. Then in edit box behind Col(B)=, type bb.
3. Click OK.
Then that col will be used to fill your current col(B).
BTW, Set Values dialog is moduless, also the dialog title shows the Col in range notation. So if you don't know how to specify the range of col(B) in Sheet1 of Book1, you can click the col(B) title in the Sheet1 of Book1. You will see the notation. E.g. Set Values - [Book1]Sheet1!Col(B).
Write it down. Then click the column you want to set value. Start to use Before Formula Script window and Formula box to specify.
BTW, there are sample formulas under Formula menu in this dialog. You can use it to see some examples.
Thanks, Snow Li
OriginLab Corp.
|
Linking Columns in different woksheet
Posted - 12/12/2008 : 11:01:26 AM
