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
 Use results of linear fit with "recalculate: auto"		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

DonTombery

Germany
2 Posts
Posted - 06/07/2017 :  02:12:32 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello, it would be great if you can help me a bit.

I need to use these resluts (screenshot) in a new worksheet but dont know how to do it with "recalculate : Auto" because it will not recalculate if any got changed

Screenshot 1: http://www.originlab.com/ftp/forum_and_kbase/Images/233.JPG

Screenshot 2: http://www.originlab.com/ftp/forum_and_kbase/Images/234.JPG

yuki_wu

896 Posts
Posted - 06/07/2017 :  04:04:55 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Have you noticed a green lock in the upper left corner of the report sheet? If the recalculate mode is manual and you change the source data in worksheet, the green lock will turn into a yellow opened lock.


Click that lock, select Recalculate Mode: Auto in the context menu. It can help to update the report sheet automatically when you change the source data.

Regards,
Yuki
OriginLab
Go to Top of Page

arstern

USA
237 Posts
Posted - 06/07/2017 :  09:56:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

You will also want to make sure that your data from the table is pasted in your worksheet so that it is linked to the analysis tabkle.

1)To do this, go to your table that you want to copy into a new sheet: Select the triangle button --> Select Create Transposed Copy As New Sheet.


2) A new worksheet will be created with the transposed table. When you double click a cell, you can see that the row is linked to the analysis sheet (sheet with the lock).


3) If you want to add an individual value from one of the tables i.e. I will add the R value to this sheet. Copy the R value from the analysis sheet. In the new sheet use Past Link. (You can also use Past Link for Copy Table).


Thanks,
Aviel
OriginLab
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