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
 Missing data when copying graphs
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

peter.cook

UK
356 Posts

Posted - 02/24/2010 :  06:22:45 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 7.5 SR7
Operating System: Windows Vista

Hi,

When I copy a graph to eg word document, some of the variables in text boxes are copied over as missing values. This occurs if the text box contains eg 'IC50 = $(value)' where the copied graph displays 'IC50 = --'

I'm sure this hasn't aways been the case but..

Any help appreciated!

Cheers,

pete

peter.cook

UK
356 Posts

Posted - 02/24/2010 :  06:42:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Can't seem to edit my own message.
Update is that if I am working offline - it works fine. Can connection to slow network be an issue?

Cheers,

Pete
Go to Top of Page

easwar

USA
1965 Posts

Posted - 02/24/2010 :  11:03:27 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Pete,

I am assuming "value" is some LabTalk variable.

For this to work with OLE-pasting into word, here is a workaround:

Save the variable into the graph page itself. So for example you can create your own section and variable value entries in the graph page by keeping the graph page active and typing in script window:
page.info.add(myvars);
page.info.myvars.ic50=10.5;

Then you can set up the label in the graph with the text:
My IC50 = $(page.info.myvars.ic50)
and then check the "Link to variables" check box.

Then it will display fine in Origin as well as in OLE-paste in Word.

In other words, if the variable you want is some global var in LT there does not appear to be a way to include that in the OLE paste other than saving it in the graph page first.

Easwar
OriginLab

P.S. The above suggests saving the var into page.info and use it from the page.info. But that means duplication of the var, so maybe the simpler solution is that you make the text in the graph static, and not link to the variable. So if you are programmatically adding the text maybe just make the text static. We will look into better support for this issue in future version.
Go to Top of Page

peter.cook

UK
356 Posts

Posted - 02/24/2010 :  12:03:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Easwar,

Thanks for quick reply. I am confused as to why it sometimes works then at all...as it has in the past - albeit winows 2000.

if I copy (Edit - Copy Page) the page to Excel it always retains the labtalk variables. if I then copy the excel embedded graph the labtalk variables are blank.

if I amend add some of the variables to the page as you suggest and repeat the process - all variables are clear in excel and then when copied into word only those added to the page are visible.

Any thoughts?

I can of course amend all the applications as above if I need to.

Best wishes,

Cheers,

Pete
Go to Top of Page

easwar

USA
1965 Posts

Posted - 02/24/2010 :  2:12:52 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Pete,

Is there a reason you want to keep the label with the linked var? When double-clicking on the object in Word (to say edit the graph), it is going to open a new instance where the variable may not even be defined/relevant anyway?

If there is no need for linking, why not build the text label as a static text, such as using script command to set the text of the label object:
text1.text$="IC50 = $(value)";
This would then make it a static string so there would be no problem in display in the OLE object?

Easwar
OriginLab
Go to Top of Page

peter.cook

UK
356 Posts

Posted - 03/01/2010 :  05:11:03 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Easwar,

Thanks for reply. If I adopt the last solution then the user has no control over the format of the output.

Back to an original question - why do the labels sometimes work as described. You seem to imply that they would never be expected to work.

Cheers,

Pete
Go to Top of Page

easwar

USA
1965 Posts

Posted - 03/01/2010 :  10:49:04 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Pete,

When creating the text label, you can format it using LabTalk numeric formatting options, such as:

text.text$="IC50 = $(value, .4)"; // 4 decimal places
text.text$="IC50 = $(value, *3)"; // 3 significant digits
text.text$="IC50 = $(value, E%4.2f)"; // scientific notation


Easwar
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