| Author |
 Topic  |
|
|
anthei
Austria
8 Posts |
 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 |
|
|
cdrozdowski111
USA
247 Posts |
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
|
Edited by - cdrozdowski111 on 07/07/2015 4:05:58 PM |
 |
|
|
anthei
Austria
8 Posts |
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 |
|
|
| |
Topic |
|
|
|
Wrong Reference after Copy Worksheet