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
 How to Recalculate for worksheet columns to NONE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Konrad Beck

UK
Posts

Posted - 10/13/2016 :  10:07:04 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 2016 and Service Release Sr2 (Select Help-->About Origin):
Operating System: Windows 7

After changing from Origin 2015 to 2016, when I set column values or do any manipulation like smoothing, the column name field shows a little green icon telling me that the "Recalculate Mode" is "Auto". For my type of workflow this is most annoying, and I want to switch this OFF as a default, though in specific circumstances I still want to be able to switch this mode on.

I have played around with the System Variables --> @AUFL and @DAM without any success.

snowli

USA
1379 Posts

Posted - 10/13/2016 :  11:00:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Set column value dialog remembers the Recalcualtion mode of the last time. So if you open Set Column Value dialog and change the Recalculation mode to None, all future set column value dialog will open with Recalcualtion mode to none.


Thanks, Snow
Go to Top of Page

Konrad Beck

UK
Posts

Posted - 10/13/2016 :  12:55:30 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
"Set column value dialog remembers the Recalcualtion mode of the last time"

yes, thanks.

If I smooth the values of a column, a new column opens at the right end of the worksheet, with recalculate mode: AUTO.
And if I fit a column, all the columns in the new sheets are "recalculate mode: AUTO".
So for each function I use it seems necessary to change the default recalculate box from "AUTO" to "None"?

I hadn't had this problem w/ Origin 2015. I do remember that I had made changes in the set-up (not via the Tools menu), but can't remember how. When opening Origin, I would like the default set so that no column does anything automatically.
Go to Top of Page

snowli

USA
1379 Posts

Posted - 10/14/2016 :  2:13:49 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Set Column Value is special so you set it once and future SCV uses the last used settings.

For other analysis, e.g. fitting, smoothing, stats, etc. please choose Tools: System Varialbes.

Enter DAM as Variable name.
Enter 0 as value. 0 means no. 1 means manual, 2 means auto.

Then all fitting, smoothing, statistics, etc. result will have no green lock in your current and future Origin sessions.

Thanks, Snow
Go to Top of Page

Konrad Beck

UK
Posts

Posted - 10/19/2016 :  06:21:28 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks, snowli: that works now!
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