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
 Recalculate column does not work
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

navi

USA
1 Posts

Posted - 06/27/2022 :  2:14:12 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.9 SR1
Operating System: Windows 10

The auto recalculate option does not recalculate the column even if the referenced column is changed. For instance if I set col(b) to be = col(a), even if col(a) is changed, nothing changes in col(b). I also tried to use manual recalculate mode and when I change the value in col(a), the recalculate option is greyed out and cannot be updated. The only way to recal seems to be changing the formula. Is there an easy way to solve this?

ChaoC

USA
185 Posts

Posted - 06/27/2022 :  2:44:04 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Can you try using spreadsheet notation? So instead of col(A), just use A.
If you have an active maintenance plan, can you try updating to 2022b?

Can you also send us your project file so we can take a look?

Thanks,
Chao
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