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
 a problem about "autoupdate"
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

hfkenny

China
Posts

Posted - 07/29/2006 :  11:51:04 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin):
Operating System:
When selecting the check-box "autoupdate" in "set column values",It sometimes (not always) give a warnning box telling me that a circular reference was contained even though a number is put in it. Could anyone help me with this? Thank u!

zachary_origin

China
Posts

Posted - 07/30/2006 :  11:40:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Here is a most simple example why it will occur:
If you set column values of col(a) as col(b)+1 and select the check-box "autoupdate". Meanwhile, you set the values of col(b) as col(a)+1 and also select the check-box. Then you can image what will happen if the autoupdating takes effects. So there will give out a warning box.

Of course, your real operation is not so simple. But it must be something alike. Hope my explanation can do some help for your understanding of this problem.

Zachary
OriginLab GZ Office
Go to Top of Page

hfkenny

China
Posts

Posted - 07/31/2006 :  03:21:48 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thank you for your kind explanation. I have checked the formula many times and I am sure that no circilar reference is contained. If a circular reference is contained, it should give the warnning box every time. It may be all right at beginning, but jumps the box after a column value is changed or even nothing changes .
Go to Top of Page

zachary_origin

China
Posts

Posted - 07/31/2006 :  03:31:58 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Can you send us your .opj file to tech@originlab.com ?

Zachary
OriginLab GZ Office
Go to Top of Page

hfkenny

China
Posts

Posted - 08/01/2006 :  10:07:35 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Ok,a sample has sent to you. In this case, the values of column A and B are set to equal their row numbers, column C equals "A+B". After adding two extra column (D and F) and let them move foward, the "autoupdate" of column C no longer works.

Thank you!
Go to Top of Page

zachary_origin

China
Posts

Posted - 08/02/2006 :  11:16:13 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Sorry, I didn't find your mail in that mailbox.

But it has been reported that similar problem has appeared by other users, which has been added in our databases. I think it will be fixed for the next version.

Thanks for your posts.

Zachary
OriginLab GZ Office
Go to Top of Page

hfkenny

China
Posts

Posted - 08/06/2006 :  03:14:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
thank you for your information. Is there any patch available now?
Go to Top of Page

zachary_origin

China
Posts

Posted - 08/06/2006 :  10:43:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
There is no patch for 7.5 now because our developers are busying with the release for the new version 8.0.

Zachary
OriginLab GZ Office
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