The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum

Completely buggy "Calculate values" in worksheets

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:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
a_h	Posted - 07/26/2022 : 04:50:30 AM Origin Ver. and Service Release (Select Help-->About Origin): 9.4.2.380 Operating System: Win10 Hi, we are using Origin for more than 10 years now and since many, many years and several different Origin versions we have consistent issues with the "calculate values" function that we use often to calculate values for columns using data from other columns. For us that's a very important function and I'm regularly suprised that it sometimes works and then the same equation transfered to a different work sheet suddenly results in really strange and obviously wrong results. Nothing that I do fixes or persuades Origin to calculate correct results. When that happens more strange things appear like A(1) gives different results than using A1. I attach a few figures with obviously wrong examples: dFe and dAl columns shall contain the difference between the values of increasing lines of columns Fe and Al. As one can see Fe and Al change, but not a single value of dFe and dAl is correct. The 2nd image (errors_2) is even worse: in column B (mileage) the first line should give +1, instead its the fractional value -0.01429. That's a sort of not obviously wrong results which might go unnoticed. Today I lost my nerves about this and I had that too many times today and I kindly ask to fix this - or let me know what I'm doing wrong as I cannot find it out myself. Thank you!
6 L A T E S T R E P L I E S (Newest First)
a_h	Posted - 07/26/2022 : 10:24:17 AM And learned something new again - awesome!! Many thanks!! I should have asked much, much earlier!
snowli	Posted - 07/26/2022 : 09:28:02 AM Suppose B is Y column and A is X. B(1) is used to do interpolation to get B value where x=1. B1 & B[1] means first cell in column B. E.g. https://www.originlab.com/doc/LabTalk/guide/Interpolation Thanks, Snow
a_h	Posted - 07/26/2022 : 08:26:57 AM Excellent!!! Thank you!!! So I was doing it wrong then for years! Why is it at all possible to use wrong notation? This is strongly misleading as it works many times (until Origin suddenly decides to no longer calculate correctly). No warning? No error?
minimax	Posted - 07/26/2022 : 05:08:32 AM You should use square brackets [] for cell access, i.e. A-A[1]+1 i==1?0:G[i]-G[i-1]
a_h	Posted - 07/26/2022 : 05:02:26 AM Also I need to clearly mention that this does not always happen. For the posted cases, I use the same simple equations in other work books of the same project file and there it works. Then I copy the equation to another workbook and there it stops working and calulates garbage. When that happens, some of the other equations in the previously working workbooks keep working, but others start to calculate wrong values also, e.g. A(i)-A(1) results suddenly in -1 for line 1 etc.
a_h	Posted - 07/26/2022 : 04:55:32 AM While I uploaded the images, they won't show up in my post. So here are the links: https://sde.v2c2.at/public/4079b0 https://sde.v2c2.at/public/68830a

The Origin Forum

Snitz Forums 2000