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
 All Forums
 Origin Forum
 Origin Forum
 templates and figures

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
cs_hodges2 Posted - 02/03/2005 : 10:15:30 AM
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.
3   L A T E S T    R E P L I E S    (Newest First)
schalkbe Posted - 02/04/2005 : 07:33:10 AM
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;
};
Mike Buess Posted - 02/03/2005 : 10:43:01 AM
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
Mike Posted - 02/03/2005 : 10:28:31 AM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000