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
 get worksheet name label

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
a_user Posted - 08/14/1998 : 5:04:00 PM
hi everybody,
i have got a problem with the label of my worksheet (the label which can
be set in the window rename menu). By default this label is set to the
name of the imported ascii file automatically. now i need to retrieve
this label text i.e. the imported filename (very long) into a variable.

does anybody know how to do this ?

thanx in advance,
thorsten

2   L A T E S T    R E P L I E S    (Newest First)
a_user Posted - 08/17/1998 : 7:54:00 PM
Origin Child Window Names and Labels

Origin supports both Names and Labels for Child Windows (Worksheet, Graph, Matrix and Layout pages). The property that controls what gets displayed in the window Title is:

PAGE.TITLE

which can take on the following values:

•0 = Display Name - Label may not be set (default) •1 = Display Label only •2 = Display Name only •3 = Diplay both Name and Label

The string value of the Label is stored in:

PAGE.LABEL

which can be accessed by:

•page.label$="Test #5104 without stabilizer"; to set a label •%M=page.label$; to read a label into the %M variable

You can type %L=PAGE.LABEL$; into the Tools:Worksheet Script text box and check the "Run Script Automatically after Import" box to have a Worksheet update the %L variable after every Import.

The %E variable contains the Name (never the Label) of the last worksheet to contain a selection other than a single cell. As such, its use in automation should be carefully crafted to also check worksheet selection properties.

a_user Posted - 08/17/1998 : 7:52:00 PM
Worksheet name

Hello,

Origin stores the Worksheet name in the variable %E and you can use this one for your purposes. I often had problems because the variable was empty. For my applications I could use %H instead (resp. %E=%H). You can check this with the command "type -b %H" or ... %E in the script window. You will get problems with long filenames. The window name cannot be longer than 12 characters or something alike. If you perform some actions with Origin %E or %H will loose their values. I could not figure out why and when yet.

Hope this helps, Peter


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