| Author |
 Topic  |
|
|
s.ret
5 Posts |
 Posted - 01/20/2009 : 09:25:35 AM
|
Hi,
I'm a rather unexperienced origin user, just getting started.
My problem:
I'm trying to create a new worksheet using the Extract Worksheet Data function.
The condition is: A(i+1)>=A(i)+0,01
This works perfectly with a testing sheet including only 25 rows. But if I try to apply the condition to another worksheet, containing a lot more rows, the condition is not accepted. If I do test changing from Addition to Multiplication, the operation is finished successful.
If anyone has an idea, how to solve the problem, I would be grateful.
Origin Ver. and SR (Select Help-->About Origin): 8.0 SR4
Operating System: WIN XP |
|
|
greg
USA
1379 Posts |
Posted - 01/20/2009 : 10:29:59 AM
|
I cannot think of any reason why this would not work.
It is not clear from your description HOW it does not work. Do you mean that the 'Test' button finds no rows that fit the condition? If that is the case, and that changing from
A(i+1)>=A(i)+0,01
to
A(i+1)>=A(i)*0,01
DOES work, then maybe the data in the second worksheet is different enough that the condition really is working.
Send your OPJ to tech@originlab.com and we will have a look. |
 |
|
|
greg
USA
1379 Posts |
Posted - 01/20/2009 : 3:39:44 PM
|
My bad ...
this notation requires square brackets [ ]
not parentheses ( ). Not sure why it works in some cases.
So your condition should be:
A[i+1]>=A[i]+0,01
or as I would use in US:
A[i+1]>=A[i]+0.01
|
|
|
|
s.ret
5 Posts |
Posted - 01/21/2009 : 05:30:37 AM
|
Thanks,
this was the hint I was looking for, couldn't find it in the manual.
It's working. |
|
|
| |
Topic |
|
|
|
Extract Worksheet Data