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
 Multiple columns operations		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

victorsch2

1 Posts
Posted - 12/18/2012 :  5:34:58 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Echo_Chu

China
Posts
Posted - 12/19/2012 :  04:41:25 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
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