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
 get worksheet name label
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

a_user

USA
0 Posts

Posted - 08/14/1998 :  5:04:00 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

a_user

USA
0 Posts

Posted - 08/17/1998 :  7:52:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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

Go to Top of Page

a_user

USA
0 Posts

Posted - 08/17/1998 :  7:54:00 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.

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