The Origin Forum
File Exchange
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Automatic calculation of rows using other sheets

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List

* Forum Code is ON
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
MartinCS Posted - 06/20/2012 : 04:18:26 AM
Origin Ver. and Service Release (Select Help-->About Origin): 8.0951
Operating System: Windows 7

I am calculating a number of cell entries for several rows automatically after entering new values in a certain row (sheet Sheet1 of my book). One of the things is a linear fit of the data. The result is given in the usual new sheet of my book (in my case it is a new sheet called FitNL2)
Since I need the fitted parameters i get them using the "calculate values" option with the script "range slope=FitNL2!B8" before the calculation and using "slope[2]" as calculation formula. It works and gives me the slope of the fit, that is stored in the cell B8[2] of sheet FitNL2. The problem only is, i want to recalculate this value automatically, but every time i enter a new value and the whole recalculation procedure is starting, the "recalculate automatically"-flag in the respective column vanishes and the value is not recalculated. All other rows are recalculated correctly, also the fit is done new.
Can I somehow give the order of the recalculation? maybe he has a problem with the order in the meaning that he wants to get the value from the other sheet before it is recalculated or whatever.
Or is it in general not possible to get values from other sheets automatically at all?
Even setting it from "automatically recalculate" to "manually recalculate" it deleted the respective flag after i entered a new value.

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