| T O P I C R E V I E W |
| Flopi |
Posted - 04/04/2017 : 3:43:14 PM
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 04/05/2017 : 11:56:17 AM
To prevent column short name changing when insert delete column, turn off Spread Sheet Cell notation, if you are not using it anyway.
CP
|
| Flopi |
Posted - 04/05/2017 : 11:44:20 AM
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...
|
| cpyang |
Posted - 04/04/2017 : 6:13:48 PM
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
|
