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
 Inserting new columns without screwing the rest		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Flopi

Canada
9 Posts
Posted - 04/04/2017 :  3:43:14 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi all,
I'm facing a recurring problem. It's not fundamental but rather annoying: I'm setting some calculations on columns on workbooks using 'set column values' for example =col(V) - 3*col(Q)

However, let us imagine that I want to insert a column between R and S.
This will shift all the names of the columns after R and my previous equation will then point to another column with other values. The only solution is to change all the columns equation by hand to point to the correct column, but it is very time consuming. Do you have any idea on how to do it more quickly ?

Thanks for the answers

cpyang

USA
1406 Posts
Posted - 04/04/2017 :  6:13:48 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
If you are using 2017, then there is no such problem, Origin will take care of the formula update when columns are inserted or deleted. See

http://www.originlab.com/Index.aspx?go=Support/VideoTutorials&pid=3258

and
http://www.originlab.com/doc/Origin-Help/Wks-SetColVal-QuickStart

and get down to "A Note: When Column Formulas do not Automatically Update"

CP
Go to Top of Page

Flopi

Canada
9 Posts
Posted - 04/05/2017 :  11:44:20 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks for the answer.
Unfortunately, most of my cases imply "Before formula script" so I guess I'll still have to do it by hand...
Go to Top of Page

cpyang

USA
1406 Posts
Posted - 04/05/2017 :  11:56:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
To prevent column short name changing when insert delete column, turn off Spread Sheet Cell notation, if you are not using it anyway.

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