| T O P I C R E V I E W |
| schneide |
Posted - 12/11/2014 : 12:18:54 PM
Origin Ver. and Service Release (Select Help-->About Origin):
9.10G 64bit b215
Operating System:Win 7 SP1
When I enter "i" in the worksheet row F(x) normally the row numbers appear in the column.
Now I have a file where instead of 1,2,3,4.... some old data appear in the column.
None of the operations using i as the row index will work.
How can it happen that "i" is replaced by not even integer values?
I deleted all contents in the project, but as soon as I open an new book the problem will be there. How can I get my row index "i" back?
Anybody any idea?
Giselher |
| 5 L A T E S T R E P L I E S (Newest First) |
| lkb0221 |
Posted - 12/16/2014 : 10:44:29 AM
The problem is caused by pre-defined i overwritten by Project Variables.
http://www.originlab.com/doc/LabTalk/guide/Data-Types-and-vars#Scope_of_Variables
So if any of you run into the same problem, please open Script Window and go to Tools: Variables... to see if there is variables with the same name. |
| lkb0221 |
Posted - 12/12/2014 : 1:44:28 PM
Hi,
I've got your data and sent you email to explain the issue. Please check.
Zheng
OriginLab |
| snowli |
Posted - 12/12/2014 : 12:55:12 PM
Yes, Giselher,
If you could send us the data, it will be much easier to figure out what is the logic behind it and if it's a bug.
Please feel free to email your opj to tech@originlab.com
Thanks, Snow |
| schneide |
Posted - 12/12/2014 : 01:57:33 AM
The data are like:
| A(X) | B(Y)
F(x) | i | col(A)[i]
| 18.11463 | -20.55197
| 15.04496 | -20.35128
| 11.97529 | -15.84054
| 8.90562 | -6.44272
| 5.83595 | 2.76628
| 2.76628 | 11.97529
| -0.30338 | --
| -3.37305 | --
| -6.44272 | --
and so on......
The number of rows corresponds to the number of rows used for data in another workbook.
There are no entries in the set column value dialog
There are no entries in the Before Formula script panel
I will send the opj. file
it shows in any new workbook
When I start origin anew and don't open the project containing such a defective workbook everything is behaving just fine.
What I did previously is using a loop command in the before script panel with containing i as loop variable (see my other post of 12/11/2014). I tried different syntax, so I suspect this might have caused the problem.
Giselher |
| snowli |
Posted - 12/11/2014 : 6:03:30 PM
Could you let us know what odd data appear in the column?
Could you open the Set Column Value dialog of that column to see if what the formula is in the column?
Is it possible you have some script in Before Fomular Script panel which set the values in this column?
Is it possible that you could send your opj to tech@originlab.com.
And if it shows in any new Workbook you created, it's possible that you have customized Origin.otw under your User Files Folder. If so, maybe you can try to delete Origin.otw under User Files Folder and see if it fixes the issue.
Thanks, Snow |
