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
 set as X on a script

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
baron_pasteur 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
1   L A T E S T    R E P L I E S    (Newest First)
Deanna 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

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