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
 templates and figures		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

cs_hodges2

UK
1 Posts
Posted - 02/03/2005 :  10:15:30 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version (Select Help-->About Origin): 7.5
Operating System:XP (home)

Hello,

my question relates to opening a worksheet template. I have a few columns with fixed values in them, and then several empty columns for me to import the ASCII file into, and then several more columns with functions set to autoupdate. My problem is simple: when I open the template the columns that should contain the fixed values are empty, even though the SetColumnValues indicates the value I want to appear in the column. As a result the AutoUpdate has nothing to update and the remaining columns are therefore empty. Can you help?

Chris.

Mike

USA
357 Posts
Posted - 02/03/2005 :  10:28:31 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Chris,

Origin templates do not store data. You might consider saving your worksheet as an OGW file (File:Save Window As...). This will retain template settings, too.

Mike
OriginLab
Go to Top of Page

Mike Buess

USA
3037 Posts
Posted - 02/03/2005 :  10:43:01 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Chris,

As you discovered, data values are not saved with the template. I see two workarounds...

1. Fill the worksheet with the fixed values and save as a worksheet file (OGW) rather than template (OTW). (Use File->Save Window As instead of File->Save Template As.) Then use the worksheet file rather than template.

2. Fill the worksheet with the fixed values and export as ASCII using File->Export ASCII. (If template name is MyTemplate save ASCII file as MyTemplate.dat on your user path.) Use the template like this...

win -t D MyTemplate; // create a wks from template
open -w %YMyTemplate.dat; // import fixed data

Autoupdate might present a problem for saving only the fixed values by both methods. Post again if you have problems with that.

Mike Buess
Origin WebRing Member
Go to Top of Page

schalkbe

Germany
9 Posts
Posted - 02/04/2005 :  07:33:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Chris,

create a button in the worksheet template with "Script, Run After" set to "Window Create". Place the initialisation code for your fixed value columns there.

E.g. to set row 1 to 10 in column C to a value of 2 the code is
for (ii=1;ii<=10;ii++) {
  %H_C[ii]=2;
};
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