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
 Multiple columns operations

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
victorsch2 Posted - 12/18/2012 : 5:34:58 PM
hello there friends,
I was using the tool "Mathematics" > simple Math, from the option "Analysis" (OriginPro8) and couldnīt have a subtraction of a constant in many columns at one time. I have too many data to treat, so it cannot be done one by one... Any ideas?
Thank you so much
Nina
1   L A T E S T    R E P L I E S    (Newest First)
Echo_Chu Posted - 12/19/2012 : 04:41:25 AM
Hi, Victor

You may use script as below. It loops all columns in the worksheet and
subtract 5 from them

loop(i,1,wks.ncols)
{
	vmathtool ix1:=wcol(i) operator:=sub constant:=5 ox:=<new>;
}



Echo

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