The Origin Forum - set as X on a script

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

set as X on a script

New Topic

Reply to Topic

Printer Friendly

Author

Topic

baron_pasteur

France
1 Posts

Posted - 04/27/2009 : 07:58:56 AM

Origin Ver. and Service Release (Select Help-->About Origin): Origin 8
Operating System: Windows XP

Hi,

I have made an import filter including advanced filter options to do automatic copy of some column in a new sheet. The problem is that the X column is transformed in Y copied column. How can I do to maintain the format of the copied column ?
I used as well:

colcopy irng:=A[1]:B[200] orng:=Sheet1!1:2 par:=1;

or

copydata irng:=A[1]:B[200] orng:=Sheet1!1:2 par:=1;

with the same result, the transformation of X to Y.

Thanks for the answer

Bruno

Plate Forme de Biophysique des Macromol�cules et de leurs Interactions
http://www.pasteur.fr/recherche/genopole/PFBiophysique
Institut Pasteur
25 rue du Dr Roux
75015 Paris
33 1 44 38 94 74

Deanna

China
Posts

Posted - 04/28/2009 : 02:06:43 AM

Hi Baron,

The copydata X-Function does not change the column types in the output range. But for the colcopy X-Function, there is an option format. If you set it to 1, the formats including column types of source columns will be applied to the destination columns. So you can use the following script command, if you want to duplicate the column formats:

colcopy irng:=A[1]:B[200] orng:=Sheet1!1:2 par:=1 format:=1

Deanna
OriginLab Technical Services

Edited by - Deanna on 04/28/2009 02:09:31 AM

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000