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
|
|
|