Author |
Topic |
|
schneide
Germany
45 Posts |
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 |
|
snowli
USA
1398 Posts |
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 |
Edited by - snowli on 12/11/2014 6:16:14 PM |
|
|
schneide
Germany
45 Posts |
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 |
Edited by - schneide on 12/12/2014 02:09:10 AM |
|
|
snowli
USA
1398 Posts |
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 |
|
|
lkb0221
China
497 Posts |
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 |
|
|
lkb0221
China
497 Posts |
|
|
Topic |
|