| T O P I C R E V I E W |
| couturier |
Posted - 01/09/2008 : 05:55:26 AM
Origin Version (Select Help-->About Origin): 8Pro
Operating System: XP Pro
How do you simply specify a col from another sheet (and in another workbook) in the set column values formula ?
------
Found my answer with defining range in before formula script
Edited by - couturier on 01/09/2008 12:07:06 PM |
| 3 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 01/25/2008 : 8:53:23 PM
------in Before Formula Script
range aa = [Book3]Sheet4!col(5);
double ff = aa[6];
------in Col Formula
col(c)*ff
CP
|
| mdoloresp |
Posted - 01/25/2008 : 6:52:15 PM
That works for an entire column but how do I do it if I want to call only one cell in the column? |
| Fay_Guo |
Posted - 01/15/2008 : 12:48:32 AM
Hi,
The following paragraph is extracted from Origin CHM help. Hope it is helpful for you.
quote:
To refer to a range of data in another worksheet, define the range as a variable, using the Before Formula Scripts box. For example, you would type something like range a = [book1]data1!col(C ) in the bottom panel. In the Column Formula panel, you could then refer to the data in [book1]data1!col(C ) using the variable a (for example, col(B)= col(A)*a).
Press F1 when Set Column Values dialog is opened. And then you can get the detailed help about your question.
Thanks
Fay
Originlab Technical Service |
