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
 recalculate button does not work?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

smaron

France
3 Posts
Posted - 11/16/2016 :  09:49:45 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version: 2016 (9.3) and Service Release: 2
Operating System: Windows 7



Hi,
I moved from Origin 8.6 or 9.1 to Origin2016 (9.3).
When I changed a value in a column, the recalculate button (if I had a calcul on the column, in manual mode) changed its color from green to yellow on my previous version. But not now...

Where is the trouble?

Thanks for your answer,

Sébastien Maron
École polytechnique
Laboratoire PMC
91 128 Palaiseau Cedex

Hideo Fujii

USA
1582 Posts
Posted - 11/16/2016 :  4:03:35 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sébastien Maron,

It the formula in the Set Column Values was working in Origin 9.1, it should also work in Origin 2016.
But, I cannot say exactly what happened because I don't see the actual situation. Maybe you can post
the formula of the Set Column Value (and the Before Formula Script if you have) here. Could you please?

--Hideo Fujii
OriginLab
Go to Top of Page

smaron

France
3 Posts
Posted - 11/17/2016 :  03:16:00 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Hideo,

the set column formulae is: col(c)=(max(col(b))-col(b))/max(col(b)), without script before.

Thanks for your help.

sm

Sébastien Maron
École polytechnique
Laboratoire PMC
91 128 Palaiseau Cedex
Go to Top of Page

Hideo Fujii

USA
1582 Posts
Posted - 11/17/2016 :  11:02:43 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Sébastien Maron,

I have tried your formula in my Origin 2016, and Recalculation works fine. Not sure what happened,
and it might be something specific in your Origin file. I can try to reproduce your problem,
could you please send me your Origin file (.OPJ) to tech@originlab.com with a subject line, ATTN. Hideo ?

Thank you.

--Hideo Fujii

P.S.
Not a matter of correctness, but your formula seems not so efficient because every time to calculate
the value a cell value in column C, Origin has to go back to the column B, and compute the max of col(B).
It would be more efficient and cleaner with the code like:
Before Formula Script:  mxb=max(col(b));
Col(C): (mxb-col(b))/mxb
Edited by - Hideo Fujii on 11/17/2016 11:04:10 AM
Go to Top of Page

smaron

France
3 Posts
Posted - 11/18/2016 :  03:18:57 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Hideo,

I sent to you an .opj file.

Thanks a lot

Sébastien Maron
École polytechnique
Laboratoire PMC
91 128 Palaiseau Cedex
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