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
 Copying worksheet column format to several wks

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
MUBJ Posted - 01/16/2005 : 10:23:07 AM
Origin Version (Select Help-->About Origin): 7,5
Operating System: XP

Hey everyone..

I am having trouble with naming and labelling a worksheet column format.. I am typing all the information by hand which takes to long time.. Can you copy the wks column format to several worksheets..?

I am wondering is there an easier way?? (sure there is I just cant find it.. :-))

I am using a script on all the data in the individual worksheets but then I have to rename all the columns to the value I have speciefied in the script...

Help is much appriciated..

Regards Michael

2   L A T E S T    R E P L I E S    (Newest First)
MUBJ Posted - 01/17/2005 : 5:56:07 PM
Easwar Thanks for the quick reply.. I havent tried it yet but it sounds pretty easy..
easwar Posted - 01/16/2005 : 2:08:23 PM
Hi Michael,

You may first want to look at how to create and use worksheet templates. You can set all properties of the columns in one of your typical worksheets, such as the col name, label, column format etc and then save all the setting by saving the worksheet as a template. Later you can create a new instance of the saved template either from the GUI or using LabTalk or Origin C and fill in new data etc.

You can also programmatically get the name, format etc of a column in one worksheet and then apply those properties to a column in another worksheet. Take a look at the Column class in Origin C and methods such as GetName, SetName, GetFormat, SetFormat etc for example.

Easwar
OriginLab

Edited by - easwar on 01/16/2005 2:09:35 PM

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