The Origin Forum

The Origin Forum

All Forums

Origin Forum

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:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
lenfant	Posted - 06/09/2017 : 05:03:18 AM Hi, How to apply automatically a same function on columns in a worksheet, but only for the columns 1,3,5...2n+1? An idea? Thanks Regards, Stf
2 L A T E S T R E P L I E S (Newest First)
lenfant	Posted - 06/09/2017 : 08:04:46 AM Perfect! Thanks, Stf
AmandaLu	Posted - 06/09/2017 : 06:33:56 AM Hi, Please try labtalk script. for(ii=1;ii<=wks.ncols;ii+2) { range aa = %(ii); csetvalue col:=aa formula:="int(rnd()*100)"; } Here is the document of cstvalue X-Function: http://www.originlab.com/doc/X-Function/ref/csetvalue Thanks, Amanda OriginLab Technical Service

The Origin Forum