| Author |
 Topic  |
|
|
OndrejMM
Australia
81 Posts |
 Posted - 04/27/2010 : 01:18:27 AM
|
I’m experience a strange problem in Origin 8, our license for Origin 8.1 is on its way, but meanwhile I have to work with what I have, so this might not be related to Origin 8.1 (hopefully),…
here is the problem, I’ve set up “set value” with “before formula scripts” (see attached picture),…
it is pretty simple, I’m creating a variable “d0pr” which is a cell [2,2] in [book5]const.! worksheet,… so it all works up to this point, but when I change the number in cell [2,2] my column doesn’t get automatically updated even though it says recalculate = Auto,…
so, did I do something wrong? or is this a way is suppose to be?
another this is can I somehow rewrite the following statements that is uses worksheet “long name” instead of “short name”?
d0pr = %([book5]const.,2,2);
many thanks
 |
|
|
Penn
China
644 Posts |
Posted - 04/27/2010 : 06:18:58 AM
|
Hi,
The statement d0pr = %([book5]const.,2,2); in the Before Formula Scripts panel can not trigger the Recalculate. You can try to use the range to get a value from a cell. You can use the following script.
range rr = [book5]const.!col(2);
double d0pr = rr[2];
Penn |
 |
|
|
OndrejMM
Australia
81 Posts |
Posted - 04/27/2010 : 7:12:04 PM
|
| thanks Pann, it works as you suggested,... is this the same in OriginPro 8.1? thanks, ondrej |
|
|
|
Penn
China
644 Posts |
Posted - 04/27/2010 : 9:53:08 PM
|
Hi,
Yes, this is the same in OriginPro 8.1.
Penn |
|
|
| |
Topic |
|
|
|
set values for a column