The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Set column values		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

couturier

France
291 Posts
Posted - 01/09/2008 :  05:55:26 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Fay_Guo

China
Posts
Posted - 01/15/2008 :  12:48:32 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

mdoloresp

USA
Posts
Posted - 01/25/2008 :  6:52:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
That works for an entire column but how do I do it if I want to call only one cell in the column?
Go to Top of Page

cpyang

USA
1406 Posts
Posted - 01/25/2008 :  8:53:23 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
------in Before Formula Script

range aa = [Book3]Sheet4!col(5);
double ff = aa[6];

------in Col Formula

col(c)*ff


CP
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000