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
 All Forums
 Origin Forum
 Origin Forum
 HOWTO: 'Set Column Values' from other workbooks

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
brendanarnold Posted - 05/29/2008 : 12:51:53 PM
Origin Version 8 SR1
Operating System: Windows XP

The new notation (i.e. [BookName]SheetName!Col(ColRef) )for referring to columns in another workbook does not seem to work in the 'Set Column Dialogue' for Origin 8 SR1. In order to work around this, expand the 'Before Formula Scripts' box in the dialogue and enter

range varname = [BookName]SheetName!Col(ColRef)


And then enter 'varname' in the main 'Set Column Dialogue' text field. make sure 'varname' does not clash with an already declared variable name in Origin by typing 'list a' in the main code window.

Regards,

Brendan Arnold
1   L A T E S T    R E P L I E S    (Newest First)
easwar Posted - 05/30/2008 : 5:21:29 PM
Hi Brendan,

Yes, the "Before Formula Script" panel can be used to run any script prior to computing the formula, and such script can include definition of range variables and other variables as well.

BUT, if you explicitly define a variable in that panel, such as your range definition, the scope of that variable is only within that panel and it does not clash with global variables.

That is how it is supposed to work, and how it works, when we test. Do you see otherwise?

For example, if you have a global varible
aa=10
and in the before formula script you declare
double aa=20;
thus explicitly declaring a double aa variable, then the aa inside the panel is a different variable from the global aa variable, and can have a different value.

You can check by putting "list a;" or other commands such as "aa=;" etc inside that panel to dump the values.

Easwar
OriginLab

[/quote]

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000