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 for Programming
 LabTalk Forum
 Formatting multiple workbooks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Clairekun

Germany
175 Posts

Posted - 01/31/2013 :  05:48:15 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 9
Operating System: Windows 7

Hello,

I need a way to allow rich text in Long Name row for all worksbooks, because I work with wavelengths and desire to set the Long Name to lambda (the greek symbol).

I use the following script to rename column headers in general:

doc -e W {
col(A)[L]$ = "\g (l)";
col(A)[U]$ = "nm"
}

I would only need to add a formatting line there for Long Name cells.

greg

USA
1378 Posts

Posted - 02/01/2013 :  10:59:55 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You should save your default Origin Workbook Template with "Rich Text" enabled for Long Names.

Press F4 to open the Worksheet Properties dialog
Click the Format tab
Change "Apply To" to "Long Name"
Check the Rich Text checkbox
Click OK

If you must programmatically apply this formatting, then do the following:

Edit your worksheet formatting as above
In the Command Window, execute
@WEF = 1
Right-click in the left half of the blank cell in the upper left of your worksheet and choose "Edit Formatting"
Click the Save As... button
Give this Theme a name and (optional) a description and click OK

Now, whenever you need this formatting for an active Worksheet, run

themeApply2w theme:="My Theme Name" option:=active;
Go to Top of Page

Clairekun

Germany
175 Posts

Posted - 02/06/2013 :  04:38:15 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks!! That did the trick.
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