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
 recalculate button does not work?

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
smaron Posted - 11/16/2016 : 09:49:45 AM
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
4   L A T E S T    R E P L I E S    (Newest First)
smaron Posted - 11/18/2016 : 03:18:57 AM
Hi Hideo,

I sent to you an .opj file.

Thanks a lot

Sébastien Maron
École polytechnique
Laboratoire PMC
91 128 Palaiseau Cedex
Hideo Fujii Posted - 11/17/2016 : 11:02:43 AM
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
smaron Posted - 11/17/2016 : 03:16:00 AM
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
Hideo Fujii Posted - 11/16/2016 : 4:03:35 PM
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

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