The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Row index i is messed up
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

schneide

Germany
45 Posts

Posted - 12/11/2014 :  12:18:54 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

schneide

Germany
45 Posts

Posted - 12/12/2014 :  01:57:33 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1398 Posts

Posted - 12/12/2014 :  12:55:12 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

lkb0221

China
497 Posts

Posted - 12/12/2014 :  1:44:28 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I've got your data and sent you email to explain the issue. Please check.

Zheng
OriginLab
Go to Top of Page

lkb0221

China
497 Posts

Posted - 12/16/2014 :  10:44:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.

Edited by - lkb0221 on 12/16/2014 10:46:07 AM
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000