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
 How to refer to a column in another worksheet		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

vlnew

United Kingdom
35 Posts
Posted - 02/14/2023 :  5:30:37 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 2022 and Service Release (Select Help-->About Origin):
Operating System: Win 10

Hello,
I want to use the "set column values" dialog to divide a column that sits in one worksheet by a column that sits in another worksheet. Could you please tell me how to refer to an arbitrary column in an arbitrary worksheet (of the same project)?
Thanks!

Shirley_GZ

China
Posts
Posted - 02/15/2023 :  12:48:25 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi vlnew,

Within the Set Column Values dialog, you can define a range variable using RangeString syntax in the Before Formula Scripts panel,
https://www.originlab.com/doc/en/LabTalk/guide/Range-Notation#Types_of_Range_Data
Or, you can select Variables: Add Range Variable to browse and define the reference column as a range varibale.
https://www.originlab.com/doc/Tutorials/SetColVal#Using_Columns_from_Other_Sheets

Thanks,
Shirley
OriginLab





Originlab Technical Service Team
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