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
 Copying worksheet column format to several wks
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

MUBJ

Denmark
Posts

Posted - 01/16/2005 :  10:23:07 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

easwar

USA
1965 Posts

Posted - 01/16/2005 :  2:08:23 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

MUBJ

Denmark
Posts

Posted - 01/17/2005 :  5:56:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Easwar Thanks for the quick reply.. I havent tried it yet but it sounds pretty easy..
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