| Author |
 Topic  |
|
|
Alex B.
Russia
4 Posts |
 Posted - 02/23/2019 : 04:27:21 AM
|
I was faced with a problem of using simple cell formulas.
For example, I have the column A with natural numbers and want to calculate summ of them in the cell B1. I write the expression "=total(A)" in the cell and press Enter. Unfortunately, the formula doesn't work and I see only string "=total(A)" instead of a function value. The situation doesn't depend on which formula I use, a cell value keeps be just string. I unsuccessfully tried to find the same problem in the Internet. Could you please help me with it?
Thank you in advance for your answers! |
Edited by - Alex B. on 02/23/2019 4:41:57 PM |
|
|
Castiel
343 Posts |
Posted - 02/23/2019 : 9:13:32 PM
|
quote:
Originally posted by Alex B.
I was faced with a problem of using simple cell formulas.
For example, I have the column A with natural numbers and want to calculate summ of them in the cell B1. I write the expression "=total(A)" in the cell and press Enter. Unfortunately, the formula doesn't work and I see only string "=total(A)" instead of a function value. The situation doesn't depend on which formula I use, a cell value keeps be just string. I unsuccessfully tried to find the same problem in the Internet. Could you please help me with it?
Thank you in advance for your answers!
Origin version?
&&&&&&&&&
&&&
&&
& _____ ___________
II__|[] | | I I |
| |_|_ I I _|
< OO----OOO OO---OO
**********************************************************
|
 |
|
|
Alex B.
Russia
4 Posts |
Posted - 02/24/2019 : 06:02:46 AM
|
quote:
Originally posted by Castiel
Origin version?
There are 2 office computers. One with Windows 10 has OriginPro 2017 (64 bit) SR2, and the other with Windows 7 has OriginPro 2015 (64 bit) Beta 3. (Both computers have the problem while my own with Windows 10 and OriginPro 2018 (64 bit) SR1 works well) |
Edited by - Alex B. on 02/24/2019 06:03:17 AM |
|
|
|
Castiel
343 Posts |
Posted - 02/24/2019 : 07:02:09 AM
|
quote:
Originally posted by Alex B.
quote:
Originally posted by Castiel
Origin version?
There are 2 office computers. One with Windows 10 has OriginPro 2017 (64 bit) SR2, and the other with Windows 7 has OriginPro 2015 (64 bit) Beta 3. (Both computers have the problem while my own with Windows 10 and OriginPro 2018 (64 bit) SR1 works well)
Cell formula was first introduced in Origin 2018.
https://www.originlab.com/doc/Origin-Help/Using-Formulae-to-Set-Cell-Values
&&&&&&&&&
&&&
&&
& _____ ___________
II__|[] | | I I |
| |_|_ I I _|
< OO----OOO OO---OO
**********************************************************
|
|
|
|
Alex B.
Russia
4 Posts |
|
|
Castiel
343 Posts |
Posted - 02/24/2019 : 8:07:37 PM
|
quote:
Originally posted by Alex B.
quote:
Originally posted by Castiel
Cell formula was first introduced in Origin 2018.
https://www.originlab.com/doc/Origin-Help/Using-Formulae-to-Set-Cell-Values
D:
I'm shocked that it was introduced too late. Is there any way to make my calculations? (without installing 2018/2019 version)
There is always Set Column Values for you.
&&&&&&&&&
&&&
&&
& _____ ___________
II__|[] | | I I |
| |_|_ I I _|
< OO----OOO OO---OO
**********************************************************
|
|
|
|
Alex B.
Russia
4 Posts |
Posted - 02/26/2019 : 06:20:19 AM
|
quote:
Originally posted by Castiel
There is always Set Column Values for you.
Yes, it's a solution, but all rows in one column will contain the same value. Actually, I need to calculate several values of such kind (median, mean, dispersion and so on), and it means that I should make a whole column for each value D:
Anyway, I got the answer for my question, thank you! |
|
|
|
Castiel
343 Posts |
Posted - 02/26/2019 : 9:15:32 PM
|
quote:
Originally posted by Alex B.
quote:
Originally posted by Castiel
There is always Set Column Values for you.
Yes, it's a solution, but all rows in one column will contain the same value. Actually, I need to calculate several values of such kind (median, mean, dispersion and so on), and it means that I should make a whole column for each value D:
Anyway, I got the answer for my question, thank you!
You can define a dataset in Before Formula Scripts and set the column values with that.
&&&&&&&&&
&&&
&&
& _____ ___________
II__|[] | | I I |
| |_|_ I I _|
< OO----OOO OO---OO
**********************************************************
|
|
|
| |
Topic |
|
Cell Formulas Problem