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
 Wrong Reference after Copy Worksheet

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
anthei Posted - 07/07/2015 : 08:06:07 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2015G (64-bit) Sr2
Operating System: Windos 7 Professional (SP1)

Hi,

I have worksheets with many columns containing formulas (all set to <Auto> mode). When I duplicate the worksheet and change column values in the new worksheet, only those columns do recalculate which contain formulas that have only col(...)-references.
Those columns, whhich contain formulas with "mixed" references like "col(A)/Constants_B[1]" do not refresh. To activate the refresh I have to manually set <Auto> to <None>-mode for the column and then use set-column-values (without changing the formula), which is quite annoying if you have to repeat this over and over again.

Any solutions?

Best regards,
anthei
2   L A T E S T    R E P L I E S    (Newest First)
anthei Posted - 07/09/2015 : 04:49:10 AM
Dear Chris,

I have uploaded the file "testfile.opj" to the "\incoming" folder.
In the worksheet "worksheet1" change/delete column A,B,C,F or G and the <AUTO>-columns do recalculate. Duplicate the worksheet and change/delete columns: the <AUTO>-columns do not update automatically.

Best regards,
anthei
cdrozdowski111 Posted - 07/07/2015 : 4:04:27 PM
Anthei,


I am not able to reproduce your problem- formulae like "col(A)/Constants_B[1]" work for me. But I am only doing simple tests.

Can you send us your project file so that we can try to see what is going on?

Follow the directions here: http://originlab.com/index.aspx?go=Support&pid=752

Thanks,
Chris Drozdowski
Originlab Technical Support

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