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 for Programming
 LabTalk Forum
 Formatting multiple workbooks

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
Clairekun Posted - 01/31/2013 : 05:48:15 AM
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.
2   L A T E S T    R E P L I E S    (Newest First)
Clairekun Posted - 02/06/2013 : 04:38:15 AM
Thanks!! That did the trick.
greg Posted - 02/01/2013 : 10:59:55 AM
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;

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